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

paul.wilson_11350
Follow / 29 Jul 2016 at 3:43pm / Toad Data Point
Latest post by on 29 Jul 2016 at 8:48pm

Data Point 3.8 export to Excel - number of rows per sheet

Expand content
Hi, I am in the process of migrating my Data Point automations which currently run on a desktop machine using Window 7 Professional to a server running SQL Server 2012 R2. The majority of automations...

Hi,

I am in the process of migrating my Data Point automations which currently run on a desktop machine using Window 7 Professional to a server running SQL Server 2012 R2. The majority of automations create data exports in Excel .xlsx format.

My largest export currently contains over 130k rows and places them all in one sheet when using the Win7 machine. However, the export from the SQL Server machine is hitting the old excel limit of 65k on sheet1 and dumping the remainder in sheet2. Does anyone know how can I correct this issue to get the data back into one sheet?

Thanks

Unanswered 76 6 / Create an account to join the discussion.
Greener
Follow / 20 Jul 2016 at 12:20pm / Toad Data Point
Latest post by on 29 Jul 2016 at 1:42pm

TOAD error - cannot use application

Expand content
Hello, When I try to connect to Oracle database I encountered the following error: System.Collections.Generic.KeyNotFoundException The given key was not present in the dictionary. Stack Trace: at System...

Hello, 

When I try to connect to Oracle database I encountered the following error:

System.Collections.Generic.KeyNotFoundException
The given key was not present in the dictionary.
Stack Trace:
at System.Collections.Generic.Dictionary`2.get_Item(TKey key)
at Quest.Toad.Db.ConnectionProxy.Implementation.ConnectionImplementation.GetObject(Int32 objectId)
at Quest.Toad.Db.ConnectionProxy.ProxyConnection.GetImplementation()
at Quest.Toad.Db.ConnectionProxy.ProxyConnection.GetActualState()

The application cannot show database tables and then asks me to close it. 

windows 7 64 Bit, TDP 3.8.0.575 Pro edition. 

I would appreciate some help. 

Thanks, 
Chris

Answered 3638 2 / Create an account to join the discussion.
Anson1000
Follow / 28 Jul 2016 at 9:46pm / Toad Data Point
Latest post by on 29 Jul 2016 at 2:38am

How to change export file location in TOAD Data Point 4.0

Expand content
Hi All, I just install Toad Data Point 4.0. How can I change export file location?

Hi All,

I just install Toad Data Point 4.0. How can I change export file location?

19 1 / Create an account to join the discussion.