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

bill.staley
Follow / 11 Dec 2017 at 7:37pm / Toad Data Point
Latest post by on 12 Dec 2017 at 8:11am

Source of Connection credentials

Expand content
When Data Point connects to SharePoint does it use the credentials from the connection, or, does it use the credentials from the computer logon? We need to use a generic SharePoint login with credentials...

When Data Point connects to SharePoint does it use the credentials from the connection, or, does it use the credentials from the computer logon?

We need to use a generic SharePoint login with credentials that are different from the computer logon.  It doesn't seem to work.

Unanswered 43 1 / Create an account to join the discussion.
bill.staley
Follow / 11 Dec 2017 at 12:55pm / Toad Data Point
Latest post by on 12 Dec 2017 at 4:15am

2 users executing the same automation script?

Expand content
We need to have 2 different people execute the same automation scripts. We are a one person shop with a back up person for when the primary person is ill or on vacation. TIC is overkill, so wondered how...

We need to have 2 different people execute the same automation scripts.  We are a one person shop with a back up person for when the primary person is ill or on vacation.  TIC is overkill, so wondered how to accomplish this.

55 4 / Create an account to join the discussion.
ArjenLissenberg
Follow / 6 Dec 2017 at 3:19pm / Toad Data Point
Latest post by on 11 Dec 2017 at 2:06pm

After upgrade to new TIC, uploading workbooks from Viewer doesn't...

Expand content
After installing the upgrade of TIC (along with latest version of TDP) I can't upload workbooks from the TDP Viewer any more, it mentions a version of Decision Point but I can't find where that...

After installing the upgrade of TIC (along with latest version of TDP) I can't upload workbooks from the TDP Viewer any more, it mentions a version of Decision Point but I can't find where that should have been installed and whether that is part of the TDP, TIC and/or TDP Viewer package:

After clicking "Publish Workbook" I get the following error message twice:

Then I get the "Publish to Toad Intelligence Central" Window, clicking on the default folder to change where to publish it nets me:

Trying to publish it in the default "No_folder_assigned" folder results in:

The new version of TIC was installed on a new server afresh and empty so didn't have any remnants of the previous TIC version. The TDP Viewer is the same version I used with the previous TIC version. The workbook I created uses a view on TIC as data-source and I can successfully Publish the data in the workbook as dataset (even though I get the first error message from above and I can only publish in the  "No_folder_assigned" folder as choosing another folder triggers the second error winodwo from above.

123 4 / Create an account to join the discussion.