Toad Data Point - Toad World

Toad Data Point v4.0 is now available. 
Learn what's new in this release

What's better than data sharing, SQL sharing and workflow sharing?  Getting it for FREE.
Find out how you could get a FREE perpetual TOAD INTELLIGENCE CENTRAL ... $5000 valueOffer valid only until September 30th.

Toad™ Data Point is a multi-platform database query tool that’s built for anyone who needs to access data from multiple sources, quickly integrate and prepare it all, and produce datasets and reports for analysis. It dramatically simplifies data access, writing SQL queries and data preparation – all from a single tool and without needing to be a SQL expert. With Toad, you can:

  • Access almost any source from a single tool
  • Visually drag and drop to create SQL queries
  • Profile, transform and cleanse data easily
  • Automate frequent reporting tasks

Use these links below to learn more about the most popular Toad Data Point topics!


Getting Started



Mastering
Connectivity

Writing
Queries

Import/Export


Automation

New Approaches to Managing
Your Evolving  Database Environment

We’re seeing many organizations move toward agile methodologies. But with the transition from manual change-and-release management to an automated approach of continuous integration comes new challenges ...

 

How to Easily Manage Multiple
Database Platforms and Unstructured Data

Are you struggling to manage an increasingly complex database environment? If so, you’re not alone. Research shows that data growth is doubling every 18 months. And it’s not...

Community Discussion

andy.corson
Follow / 2 Aug 2016 at 1:56pm / Toad Data Point
Latest post by on 30 Aug 2016 at 3:40am

TDP 4.0 Automation Scripts Exporting Data to Excel Files with Pivot...

Expand content
I upgraded TDP to 4.0 yesterday and upgrade my automation scripts. I have several that export data to a tab in Excel files with existing pivot tables. When the scripts ran this morning, the resulting Excel...

I upgraded TDP to 4.0 yesterday and upgrade my automation scripts. I have several that export data to a tab in Excel files with existing pivot tables. When the scripts ran this morning, the resulting Excel files were corrupt and needed to be repaired. It appears as if Toad collapsed a bunch of rows in the pivot table causing the problem. I was able to fix this by selecting the entire worksheet with the pivot table and double clicking the rows to expand, then saving the repaired file and re-running the automation script. I will document this in better detail, but I just wanted to get something on the forum in case anyone else is having the same problem.

408 11 / Create an account to join the discussion.
ziying.wu
Follow / 29 Aug 2016 at 6:13pm / Toad Data Point
Latest post by on 30 Aug 2016 at 3:38am

How to connect to oracle database using Direct in Toad Data Point

Expand content
I cannot connect to oracle database from Toad Data Point using Direct. Is SID required? I also use Toad for Oracle and we use service name and it works fine. But it wouldn't let me connect if I use...

I cannot connect to oracle database from Toad Data Point using Direct. Is SID required? I also use Toad for Oracle and we use service name and it works fine. But it wouldn't let me connect if I use service name in Toad Data Point. Can somebody help?

Thanks,

Z

Unanswered 125 1 / Create an account to join the discussion.
andy.corson
Follow / 29 Aug 2016 at 6:14pm / Toad Data Point
Latest post by on 30 Aug 2016 at 3:33am

Export row count in export activity

Expand content
Is there any way to get a row count variable using the export activity? I didn't see anything in the export wizard, but the log shows the row count attempted and successful, so it has to be somewhere...

Is there any way to get a row count variable using the export activity? I didn't see anything in the export wizard, but the log shows the row count attempted and successful, so it has to be somewhere, right?

Answered 38 3 / Create an account to join the discussion.