Toad World® Forums

Toad for Data Analysts Beta 3.0.0.404 is now available on Toad World!


#1

I’m pleased to announce the start of the Toad for Data Analysts 3.0 Beta
Program. The beta build is available at:

http://usdownloads.quest.com.edgesuite.net/Repository/www.toadsoft.com/tda/ToadforDataAnalystsBeta_3.0.0.404.zip

During the 3.0 beta cycle we will be highlighting new features and enhancements
as they become available. We have provided a series of short video tutorials for
Local Storage, Data Visualization, Data Histograms and newly added providers
which can be viewed directly from the beta community page at:

http://tda.inside.quest.com/beta.jspa Please take the time to review these video
tutorials as they are an excellent resource to familiarize yourself with the new
features. We will be updating these tutorials periodically so check back when
new betas are posted.

The list of fixes and enhancements can be found in the release notes:
http://www.toadsoft.com/tda/ToadforDataAnalystsRNBeta.htm

We look forward to your participation and feedback in the Toad for Data Analysts
3.0 Beta Program.

Alan Bala

Quest Software, Inc.

Development Team Lead

949-754-8413


#2

Hi Alan,

I was a big fan of Toad for Oracle in the IT shop I used to work in and was excited to see this beta for analysts.

Where I work now, we have very large datasets and need to perform lots of queries to get the data we need often requiring interim tables.
We are considering this product as we have many data sources, some being in Access while most of the data resides in Oracle.

The deal-breaker here and the basis for my question is this:
We need to be able to write queries that make tables or views in our local storage that utilize data from both Oracle and Access. We have been trying to figure this out and have had no luck. We do not have the ability to create tables in our Oracle environment so we are hoping to automate create table statements and then manipulate those table in our local storage in Toad.
Running a query and sending the results to local storage wont do because the whole process needs to be automated and it seems that the send to local storage function is a manual step.

Is there any way to do this or are we looking at the wrong product?

Thank you very much for your help,
Joe


#3

Hi Joe,

You definitely have the right product! If you can wait about another two weeks,
we will be unveiling our new X-Query functionality in the 3.0 beta. There will
be many exciting aspects to this new feature including the ability to write
X-Queries in the SQL editor and send the result sets to local storage. And you
will be able to automate the process as well. We’d absolutely like to work
with you to demonstrate how these new features can achieve the results
you’re expecting. We will be posting a new 3.0 beta in the next day or two
and anticipate the new X-Query functionality to be included in the following
beta approximately two weeks from now. Let me know if the this doesn’t fit
your evaluation timeframe.

Alan


#4

Hi Alan,

I appreciate the quick response.
I think what you’re saying is that the functionality I’m looking for isn’t in the current beta 3.0 but will be available soon. We are in a hurry and needed this yesterday as we have outgrown Access and have some immediate needs.
Our biggest need is to be able to log into our local storage and run create table queries from there that can be automated so that the tables are recreated automatically each day after the Oracle DB is re-loaded and are ready to work with when we come in to work in the AM.
I’ve got to say that I used Toad for Oracle in the past and loved it. This beta is pretty cool but some parts are very intuitive and others are not at all.
Please tell me more about the new products but I’m not sure we can wait.

Thanks,
Joe


#5

Hi Joe,

You can do most if not all you want do in the 2.7 GA release via a combination
of cross platform queries, Import/Export and Automation. The gotcha might be the
complexity and amount of data returned by the cross platform query. The 3.0 beta
will have significant performance improvements over the current implementation
in addition to an embedded database to use for local storage. For 2.7, one
scenario might be for you to use the Import Wizard/ Add query, execute the query
creating a result set sending it to a new table on your local storage. Then you
could save the import as a template and use the template in Automation to
schedule the import to run overnight. You can create and schedule multiple
templates in the same or different jobs. We can help you on setting it up.

Alan