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...

 

Written by Robert Pound, System Engineer, Dell

Toad® Data Point is a cross-platform query and data provisioning tool that simplifies data access, querying and analysis for data management professionals. This data analysis tool provides nearly limitless data connectivity, visual query building, data cleansing and workflow automation. For more information about Toad business intelligence products go to: http://www.quest.com/business-intelligence-suite/...

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 ...

Toad Business Intelligence Suite (TBIS) is a powerful new offering from Quest Software that helps reconcile the gap that exists between:

The Analysis that is provided by traditional embedded BI Solutions and The Analysis that the Business user is actually being asked to perform. We can illustrate how the TBIS suite addresses this gap by...

For the second time in as many Toad for Data Analysts (TDA) demos I have had a prospect express interest in the ability to perform a ‘SELECT INTO’ (you may recognize this syntax or something similar depending on what DB platforms you work with) type operation for moving schema and data from an Excel object to Oracle (or any other platform) in one fell swoop. 

 

As an example, SQL Server users are used to having...

Toad for Data Analysts Automation interface is an extremely powerful and oftentimes underutilized feature. To demonstrate the power of the Automation Interface I’ve created a simple example that you can extend for your own use. We start by using the Automation Interface Execute Script feature to run a SQL query. This sql query returns a flag value which we will assign to a variable. With the variable assigned, we can use the...

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.

With the latest version of Toad for Oracle on the streets, the Toad User Conference season is with us again enabling us to showcase what’s new in Toad and other related products and for Toad users to network with each other to share experiences.

 

We have been running Toad User Groups and Conferences since 2002 and they have been extremely popular with our Toad community and with people who are new to Toad. Most...

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...

Toad for Data Analysts 3.0 will be publicly available for download next week! This latest version has tons of cool features like an improved x-platform query engine, new data cleansing and transformation capabilities, a set of sophisticated analytics, data visualization, and even an embedded database. Don’t miss this webcast with product manager Julie Hyman and Software Engineer, Amit Parikh to see some of these new features...

Sit back and relax as Jeff takes you through one of his favorite Toad features in a 5 minute video: Data Compare. 

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

If you are an everyday Toad for Data Analysts user like me, you may want to customize your interface and tailor it to your preferences. If so, Toad for Data Analysts has lots of ways you can modify your experience inside the application to make it fit your needs better and, possibly, even make your daily Toad experience a little more fun. I've added a n ew document to the Toad for Data Analysts library...

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...

For most couples, ‘date night’ is something to look forward to, but unfortunately does not come around often enough. For others, even the word ‘date’ sends a chill down their spine. It’s not an adverse reaction to their partner, but rather a unpleasant reminder to the daily toil that is working with DATE formatted data in their relational database.

If you’ve ever used the Code Snippets feature, in Toad for Data Analysts, you may have found the list to be, well, rather robust.  The solution provides snippets for the majority of database platforms supported by the solution (DB2 LUW, DB2 z/OS, SQL Server, Oracle, MySQL, Sybase, and ODBC).  Why do I want to view snippets for DB2 when I’m working with a SQL Server database?  Good question.

It appears that the latest...

By Vickie Farrell

According to Thomas Davenport in the Harvard Business Review article “Competing on Analytics,” successful analytics competitors understand their customers better and make better decisions by consistently making widespread use of...

Today I want to talk about something that should be beneficial to any person who has ever needed to connect to an Oracle database, comparing data.

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.

For those of you who haven’t yet upgraded to Toad 10, or were perhaps waiting until the first minor release, here’s a quick synopsis of what really characterizes Toad 10.

 

Toad for Oracle v10 offers new features and many enhancements to existing features, all of it designed to augment your workflow and to enable you to get your job done more productively, more accurately and with better visibility of the environment...

Often database professionals need good freeware tools to get their job done. Sometimes it’s because there’s no funding for software. And in some cases a tool is needed to replace the purchased tool that ends up not being able to do the job. Finally in today’s world of open source, some people just hate to pay for tools – even if there is budget and/or the job clearly could benefit from commercial quality tools.

For...

Many people these days have to work on both traditional “online transactional processing” (i.e. OLTP) systems as well as data warehouses. But just what is a data warehouse? Generally speaking a data warehouse is nothing more than a specialized business reporting system used by mid to senior level management to research and develop a tactical plan and/or true long term strategy. Thus in many cases while these systems may be considered mission critical, they are not really true 24 X 7 systems. Often data warehouses are utilized during normal to extended business hours, with some batch activities for data loading and aggregation/summary calculations.

...

Undocumented functionality in TDA, Toad for SqlServer, Toad for DB2 and Toad for MySQL to use advanced flow control when executing scripts.

Sometimes, I’m asked to help a customer work through a particular challenge they’re facing when using one of Quest’s solutions. Many times, the meetings are one-on-one sessions with the customer where we take turns sharing our desktops to better understand the problems being faced and how the solution might be able to address the problems. I actually enjoy the one-on-one sessions, because it gives me deeper insight into how our customers are using our solutions. Plus, it’s a great way to meet and connect with people, which is the part of my job I enjoy the most. Yes, at times, I’ve been called ‘weird’.

...

Written by Jeff Smith, Quest Solutions Architect

Toad is a brand at Quest. We have several tools that have been built explicitly for developers and administrators in the Oracle, DB2, SQL Server, and MySQL universe. After gaining the following of about 2 million users over the past decade we realized that more than a third of our users did not fall into the ‘developer’...

Like most applications, Preferences or Options enable the user to make changes to the default configuration to suit the way they work. The same is true for Toad but there are so many, for some it can be a bit of a challenge finding what they are looking for.

 

The objective of this blog is to help you get a handle on what the main options are that you probably need to know about.  Note that the screen captures...

Have you considered switching to Toad for Data Analysts but have too much invested in your old query builder? Have you ever looked at a query with a complex join clause and wished that you could see it mapped out visually? You're in luck - Toad for Data Analysts can help! Toad for Data Analysts can take your SQL statement and reverse engineer it into a visual Query Builder. In this blog post, I’ll show you how to do it quickly and easily!

We all come from different backgrounds... some of us are old Toadies, and some of us are used to different tools. Did you know that Toad for Data Analysts can be configured to act and look much like Toad for Oracle and many other tools? Even down to the keyboard shortcuts? I'll show you how.

Toad for Data Analysts v2.5 is just around the corner. In anticipation of the release, I want to highlight a few of the enhancements that we've made to the product. I'll be posting a new feature every few weeks, so stay tuned!

As I promised earlier, the focus of this blog entry will be using the Editor in Toad for Data Analysts. The Editor is where you can enter your own SQL code to query the database. Since you’re already familiar with Toad for Oracle’s Editor, you’ll notice some similarities in Toad for Data Analysts. Hopefully, these similarities will...

In Part III of this series of blogs, I’ll discuss the Query Builder in Toad for Data Analysts. In my previous entry, I said that I would talk about both the Editor and the Query Builder in Part III. Both features are so rich that I feel that separating the topics would be the best approach. So, we’ll focus on the Query Builder for this topic. 

...

Previously, we discussed how to establish connections to the database. If you’re interested in a refresher, the entry can be found here: http://www.toadworld.com/Community/Blogs/tabid/67/EntryID/382/Default.aspx Now that we’ve connected to the database, we’ll examine how to work with the database objects. 

 

Where are my...

If there's one thing we hear people asking about it's "How can I use Toad for Data Analysts to automatically update my Excel report?" This blog entry is dedicated to just that. I'll show you how you can get your Excel reports to update from the database in just a few steps - and automate the process for next time!

In this series of blog topics, I will attempt to translate certain features in Toad for Data Analysts for those of you who are more familiar with Toad for Oracle. As you may (or may not) know, Quest Software allows licensed owners of Toad for Oracle 9.7 to use Toad for Data Analysts free of charge! Toad for Data Analysts is Quest Software’s cross-database platform Query and Reporting tool. For Developers and DBAs who work predominately in Oracle, but have the need to query and/or report against other database platforms (SQL Server, DB2, and Sybase, just to name a few), then the pairing of Toad for Oracle and Toad for Data Analysts is for you. 

...

I recently performed 3 separate Toad for Oracle web demonstrations for a large company in the payroll and human resources industry.  Rather than a general overview of all Toad features, these 3 demos were customized for 3 different types of Toad users: DBA's, Analysts, and Developers.

This group of DBA's had used Toad for years, but had not upgraded recently.  As I have mentioned in previous posts, there has been a substantial amount of functionality for DBA's added to Toad in recent releases - just download the latest version.  Johannes' Toadworld blog has an excellent 3 part series on the Toad DBA Suite.

...

If you’re like many of the analysts I speak with on a regular basis, then you use Microsoft Excel. It’s a staple of the Information Age, right!? It seems like you can do everything but wash your car with Excel. But what if you want to get that data out of your database and into a series of worksheets… on a regular basis…? Unless you have lots of free time, this is probably something that you don’t look forward to. Let’s take a look at how Toad for Data Analysts can make your Excel-life even easier!

Query Builder is the heart and soul of Toad for Data Analysis. We've spent lots of time and effort working to make it very useful and intuitive. Recently, in version 2.0 of Toad for Data Analysis, we introduced a few new features including reverse engineering SQL to a Query Builder model, creation of DDL scripts and better connection awareness. The linked doc is a very nice write up that Shawn Pickett (Senior Developer) and Alan Bala (Development Team Lead) have put together.

Toad for Data Analysis now comes included with Toad for Oracle!

In my previous blog, I covered things that you should know about Toad for Oracle’s editor. I thought for today we could spend a few minutes on what users may benefit the most from Toad’s cousin, Toad for Data Analysis. This blog will concentrate on working with SQL.

 

1.     SQL Recall   The time you’ve spent engineering...

If you’re a loyal reader, you may remember a blog I published WAAAAAAAY back in July of last year. A few things have changed since then. Users now have 2 different Toad tools to help them get data from Excel merged into the data they already have access to in the Oracle database.  

A Brief Problem Description

...