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

chad.king
Follow / 30 Aug 2016 at 5:24pm / Toad Data Point

TDP Giving Up on Query Connections with No Error in Automation

Expand content
I hope I can explain this well. This is a problem that we've had for some time, but I was really working to ensure it wasn't an issue on my end before I submitted this to TDP. I do believe it...

I hope I can explain this well.

This is a problem that we've had for some time, but I was really working to ensure it wasn't an issue on my end before I submitted this to TDP.  I do believe it may be on the TDP product end.  Essentially we use TDP 4.0, but I've seen the problem as well on earlier versions.  We have our queries that connect using an I-Series ODBC connection to an AS400 using DB2 SQL.  All of our queries use this.  With that being said, I've noticed quite frequently that long running queries (those that take possibly an hour or more to run) have issues specifically when running in automation that are essentially giving up the connection to the query and continuing to run on the machine.  Therefore, when I come in in the morning I notice that the little toad icon is still up and the automation task is still running and I have to forcibly end the task and then attempt to rerun. (It will work usually when rerunning and this issue isn't present every time the query runs, just on and off, most notably when CPU is higher and query times are running even longer than normal)  I have the ability to check the query running on the AS400 and when I do this on these queries in automation that give up and essentially keep running, I notice that the query is no longer running on the AS400.  Therefore, I'm suspecting that somehow the query either times out or is killed some how on the TDP automation end, but throws no errors back.  The reason I believe this, is I also have the ability to terminate connections to queries on our AS400 which means that I can stop a query on the AS400 side.  If this was the case, or connections get lost, I always throw back an error on the automation that the connection has been lost, which is great and tells me that it will error for connections lost on the AS400 end.  This is why I assume its something with the TDP product.  I'd like to see if the wonderful TDP support folks have seen this issue before and if not, what information I may be able to provide to help this issue to be researched.  Also, I'd love to hear if anyone else has experienced anything similar. 

Hope to hear from you soon. 

Chad

3 0 / Create an account to join the discussion.
pam_pal
Follow / 18 Aug 2016 at 8:08am / Toad Data Point
Latest post by on 30 Aug 2016 at 8:39am

Visualization feature - Grouping by Second does not work on a Datetime...

Expand content
Hi, I have measurements that occur on the same day but different time (e.g. 18/8/16 2:20:53 AM and 18/8/16 2:20:54 AM). I am attempting to plot these 2 points into a graph using the Visualisation tool...

Hi,

I have measurements that occur on the same day but different time (e.g. 18/8/16 2:20:53 AM and 18/8/16 2:20:54 AM).  I am attempting to plot these 2 points into a graph using the Visualisation tool.  I have set the Dimension Grouping to "Second" but I am getting only 1 point with the Average of the 2 measurements.

 

Unanswered 133 3 / Create an account to join the 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.