Download the FREE Toad Data Point Viewer
Toad Intelligence Central on Quest.com
Toad Intelligence Central Community on ToadWorld
Product Information on Quest.com
Toad Data Point Release Notes and Product Guides
Toad Data Point v4.3 is now available
Get more from Toad Data Point... with onsite training
Toad™ Data Point is a multi-platform data preparation tool that’s built for anyone who needs to access data from multiple sources, quickly integrate and prepare data to 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:
Use these links below to learn more about the most popular Toad Data Point topics!
I thought that his was fixed in an earlier version of TDP, but this gremlin has struck me again. I have created a calculated column that is a very simple formula for Gross Margin Dollars ( table1.Revenue - table1.COGS ). I ran this query several times throughout the day, and now it has decided that the result will be string value instead of a numerical value. This means that when I send the results to a Pivot Grid, the column will NOT behave as expected with an aggregation...no summing, averaging, etc....just a zero. How can this be fixed?
Here is a screen shot showing how the values are left aligned (as one would expect for text/strings), instead of right-aligned.
Toad Data Point 22.214.171.1248 (32 bit)
I've written my SQL query and want to export it to a QVD file so that I can load it directly into Qlik Sense, is this possible? I only see options to export to Excel or csv.
Hello, I am trying to build a simple query connecting a SQL server table and an Oracle table. I've found many items in the help and videos saying this can be done. However, I am unable to find the option to build a cross connection query. We are using TOAD Data point version 126.96.36.199. Any guidance is greatly appreciated. Thank you!