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

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 112 2 / Create an account to join the discussion.
chad.king
Follow / 30 Jun 2016 at 3:11pm / Toad Data Point
Latest post by on 28 Jul 2016 at 10:32am

Timeout Waiting for Connection from Handler FTP

Expand content
I'm using TDP 4.0 Beta and have started to often receive FTP timeouts saying timeout waiting for the packet from handler. I never experienced this in earlier versions, plus when I retry, the file goes...

I'm using TDP 4.0 Beta and have started to often receive FTP timeouts saying timeout waiting for the packet from handler.  I never experienced this in earlier versions, plus when I retry, the file goes over fine.  This is with multiple different FTP sites as well, which is odd how its happening to so many.  The question I have is, is there a way to change the timeout settings on FTP, or set up retry's, etc. for FTP processes using the FTP activity in automation?

Thanks

263 4 / Create an account to join the discussion.
BarryTheSprout
Follow / 20 Jul 2016 at 4:48pm / Toad Data Point Beta Program
Latest post by on 27 Jul 2016 at 8:13pm

Issue with Exporting All Tables from SalesForce...

Expand content
I am using TDP Beta 4.0.0.609 on Win 7 and noticed an issue when using the Export Wizard to attempt to export data from all SalesForce objects I have access to. If I select Database / Tables and choose...

I am using TDP Beta 4.0.0.609 on Win 7 and noticed an issue when using the Export Wizard to attempt to export data from all SalesForce objects I have access to.  If I select Database / Tables and choose the correct Server instance as shown below:

When I get to the Select Columns screen, all roughly 500 tables are available as seen below:

However when I execute the export, it does not see any objects and exports nothing.  I can run the Export Wizard and select Tables on the first screen, then manually select each of the 500 tables and the export will run fine. I just tried this as well in the latest TDP 3 version and hit the same issue.  Is this something that hopefully will be fixed for TDP 4 or is there a way when presented with a long list of tables in the Export Wizard you can select all of them?

I can send you .log and .txp files for both the painful manual selection process that works and the much easier process that fails if that would help.

Unanswered 80 1 / Create an account to join the discussion.