Toad World® Forums

Few Questions - Maybe Easy Answers?

Have a few (maybe easy) questions about TOAD for DAs (Data Point). Here they are:

  • Is there a way to see what the program is executing against the database?

Say, in data compare for example. Is there a session browser that shows what queries are being executed? I’d be interested in having the code from this functionality to execute in the database outside of the TDA GUI.

  • Is there a way to extract automation scripts from the GUI?

If say, I create an automated script, does it need to execute from my local machine, triggered by the TOAD GUI or can I export a script that can be stored in the database?

  • Same goes for reports (as with automation above)?

If I create a report in the TOAD GUI that I have stored in my project, can I extract this report generation somehow to complete without TOAD, say stored in Oracle as a package or procedure?

Thanks in advance for the help. I guess my questions are generally in regard to how independent what gets created in TDA can become?

I’m trying to determine if this is a tool that requires execution from my local machine (where the Toad DA software is installed) or if it can be used as a tool to help create programs that can be deployed on the remote machine where Oracle is installed (where TOAD is not).

Hello,

I’ll try to answer your questions (considering I understand them correctly):

  1. Synchronization script (i.e. script synchronizing source to target or vice versa) of the data compare project can be saved to a file for future use. It contains set of statements containing “delta” between database A and database B. Later you can load this script in any tool, connect to database A run the script and after changes are made, database A will be the same as database B.

  2. Automation script is kind of xaml describing a set of activities of the particular workflow. Because script consists of custom activities, nobody except TDP knows how to deserialize them. That is why this script should be run on the machine where TDP is installed. Of course, it’s not necessarily the machine where script was created.

  3. Same goes for reports.

Thanks,

Igor.

How do you save said synchronization scripts? What language would they be in?

Also, is there a way as mentioned to pull the code being executed (behind the scenes by TDA) when running things such as data compare?

Data compare comes out in a few columns (counts): source matched, target matched, and identical across both. What are the statements being executed for this?

Tried to find this by running TOAD for Oracle and viewing open sessions while data compare is running but there wasn’t a clear result.

Basically I’m hearing that TOAD for Data Analysts (Data Point) is only good within itself. Not as a tool to assist in development of portable scripts/code that can be deployed remotely?

No one else has information about this? Would love to get use out of this seemingly powerful tool! Just curious what the limitations are.

Thanks in advance for response!

Please find ‘Synchronization script will be saved to the file:’ entry on the 1st page of the Data Compare Synchronization Wizard. Script is just plain sql script.

As for the SQL statements that TDP runs behind the scene - I’m afraid there is no simple way see them.

Igor.

RE:

  • Is there a way to see what the program is executing against the database?

There are a couple of things that come to mind on this question, however, none of them work for every area of the product.

a) Under tools there is an “Execution Trace | To Output window or file” that will display most of the SQL that is being executed by the application, however I do not think it will show you the data compare SQL.

b) In the options, under Database| SQL Dictionary we have all of the SQL that is used by the Object Explorer and data browser. This is stored by category.

  1. In our point products (Toad for DB2, Toad for Oracle, etc) each have a session browser where you can see the SQL executed by all apps. We do not have this window in TDA as it usually requires a DBA level logon.
  • Is there a way to extract automation scripts from the GUI?
    The automation scripts are saved to a *.tas file. These scripts can be executed by another TDA as long as all dependant files are also available, such as connection.xml, *sql, *tsm, etc.

Many users install TDA on a Server and set up and run all of their automation scripts there. This server would be up all the time where local laptops, etc generally get logged off at night.

Debbie

**Few Questions - Maybe Easy Answers?
**Posted: Sep 19, 2012 3:59 PM

		Have a few (maybe easy) questions about TOAD for DAs (Data Point). Here they are:

		- Is there a way to see what the program is executing against the database?

		Say, in data compare for example. Is there a session browser that shows what queries are being executed? I'd be interested in having the code from this functionality to execute in the database outside of the TDA GUI.

		- Is there a way to extract automation scripts from the GUI?

The automation scripts are saved to a *.tas file. These scripts can be executed by another TDA as long as all dependant files are also available, such as connection.xml, *sql, *tsm, etc.

Many uses install TDA on a Server and set up and run all of their automation scripts there. This server would be up all the time where local laptops, etc generally get logged off at night.

Debbie