Upon occasion you may find a need to import data into a database. That database might be your own sandbox or you can use the Toad Sample database or Local Storage. I am going to show you three different Import Methods.



Scenario 1

The most common use case is taking an Excel or CSV file and import. Toad Data Point will import to the current connection. So connect to the sandbox that you want. I will use...

SharePoint is becoming more and more popular for content and document management. I know we use here quite a bit for storing our project schedules, architecture docs, and so on. Starting with Toad Data Analysis 3.1 we offer exporting and importing to SharePoint lists. SharePoint lists can easily be treated as a dataset. I happen to use this every month by exporting a report that shows all of the connection types that were used by Toad Data Point. Let me show you how to do this.

...

Exporting data is a key activity for automation and the Select to File activity handles most basic exporting needs. But what if you have a little bit special situation that needs to be exported? In this case you can use all features of the Export Wizard. 



Let’s look at some scenarios of when using the Export Wizard automation activity would be appropriate.

Scenario 1 – CSV files

When you have a...

For more advanced forms of formatting use Excel macros.



Macros are VBA instructions that can be triggered by Toad. By default Excel disables macros. You will need to set up Excel to use macros. When using them the excel extension is *.xlsm. The set up may vary between versions of Excel. Starting with Excel 2007 you will need to enable macros. From the office button open the Excel Option page. Click on the Trust...

Here is a report that uses pivot grids.

Single result sets exported to Excel may not be enough for your needs. You might have a project where the end user wants multiple results in a single page. And of course you would like to make it attractive.

Here are the basics on exporting to excel. We will build on this action in the next two videos to build complex reports.

Hi my name is Debbie Peabody and I'm beginning a Blog series on Automation. I have talked a lot about Automation but there are still many examples of real world scenarios that might help you out with your daily tasks.

In this Blog series I will present the data in both video and written format. In this post I will start with the basics of how to get started with Automation. (If you have been creating and running automation...

1. A small amount of query text is sent over the network from the SQL client to the RDBMS.
2. All data scanning, filtering, sorting and grouping is done locally within the RDBMS.
3. The result set is returned over the network to the SQL client program.

There are only two real opportunities for latency in this simple ...

Have more questions about Cross-Connection Queries?  Here is video FAQ on the subject.

See our Advanced Analytics library in Toad for Data Analysts.

If you need to bring together data from disparate databases, try Cross –Connection queries in Toad for Data Analysts!  This blog includes a video to show you how.

Tired of using Access? Toad for Data Analysts 3.0 Professional edition includes an embedded database for your local storage needs. Here is a quick video showing this new feature.

Toad for Data Analysts has always been able to export data to Excel with one click. New in Toad for Data Analysts is exporting to Excel Charts. This video shows how.

Toad for Data Analysts Data Reports now offers report merging, templates and multi-datasets.

Video 2 in this series covers the UI changes for Toad for Data Analysts 3.0. If you are interested in upgrading to 3.0 and would like to know about the following areas take a moment to watch!

Understand, Query, Report, Automate buttons (where did they go?) Right Click menus (Better usability) Oracle Connections (How to set up an instant client) Query Builder (How to add a column) Code Completion...

Toad for Data Analysts 3.0 is finally here! I’m sure you are all anxious to find out what’s in it and get started on playing with its new features. Here is a short video to get you going.

This is Video 1 of a series of videos covering the features of TDA 3.0.

If you would like to view them all please visit our community site.

Download a Trial copy...

In this video I review the import enhancements new to Toad for Data Analysts 2.7.

In this video I demonstrate how to download several files from a FTP site using a mask and import all of the files into one table for reporting.

                One of my favorite features of Toad for Data Analysts 2.7 (TDA) is automating complex excel reports. Most reports consist of several sets of data and formatting to make the data attractive or easily readable for the end-user. In this post I will show how to automate these kinds of reports with a combination of export and excel macros.

                My sample Sales report consists of the Top 5 products...

In this blog I'll discuss how to debug a Toad for Data Analysts Automation Script.

In this posting I show how to automate exporting and importing and highlight the new changes in this area for Toad for Data Analysts 2.6.

In this posting I'll show you what Toad for Data Analysts has to offer when using SQL Date Ranges

In this post I’ll show you how to define and use automation variables to email a customized lettes to an email list.

In this post I'll show how to produce an exception report using the row count variable and if..condition automation activity.

Scripting repetitive tasks can ease your work load. Here's how to do it in TDA.