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:

  • 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

Community Discussion

InfoMan
Follow / 19 Apr 2018 at 9:54pm / Toad Data Point
Latest post by on 19 Apr 2018 at 10:05pm

Calculated Column returns as a string instead of a number value

Expand content
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...

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 4.3.0.718 (32 bit)

Unanswered 82 1 / Create an account to join the discussion.
MR BARKER
Follow / 17 Apr 2018 at 10:59pm / Toad Data Point
Latest post by on 19 Apr 2018 at 6:24pm

How to export SQL script to Qlik Sense QVD

Expand content
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. Thanks

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.

Thanks

Unanswered 137 3 / Create an account to join the discussion.
tracy.bakowski
Follow / 18 Apr 2018 at 4:08pm / Toad Data Point
Latest post by on 18 Apr 2018 at 8:43pm

Cross Connection Queries

Expand content
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...

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 4.1.0.226.  Any guidance is greatly appreciated. Thank you!

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