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

hharwood
Follow / 15 Feb 2018 at 7:17pm / Toad Data Point
Latest post by on 20 Feb 2018 at 9:40pm

File path issue with publishing automation scripts to Intelligence...

Expand content
Using Toad Data Point 4.3.0.718 (32 bit) and Toad Intelligence Central 4.3.0.126. Long story, but server we installed TIC on does not have access to the same network file share we do as developers, so...

Using Toad Data Point 4.3.0.718 (32 bit) and Toad Intelligence Central 4.3.0.126. Long story, but server we installed TIC on does not have access to the same network file share we do as developers, so TIC will have to work with local file mapping, and I am having trouble getting file path mappings to work between running it from my notebook and publishing it to TIC to run there. Note that these scripts load data files into tables (ETL processing).

Is there any way to stop publishing from forcing the uncheck of Use Relative Path to Find Files in the Settings, or to stop steps like Copy File from converting drive letters (like E:) to UNC paths (\\server\share)? I've been trying various schemes, but do not seem to be able to have the script work from my notebook to a network file share and then publish it to TIC and have it work there as well.

583 17 / Create an account to join the discussion.
ArjenLissenberg
Follow / 19 Feb 2018 at 4:21pm / Toad Data Point
Latest post by on 20 Feb 2018 at 3:46pm

parameter in Where clause in Data Compare

Expand content
Is it possible to include a parameter in the Source Where clause and Target Where clause in a "Compare" module? I tried the ':' and '#*#' way of introducing a parameter/variable...

Is it possible to include a parameter in the Source Where clause and Target Where clause in a "Compare" module? I tried the ':'  and '#*#' way of introducing a parameter/variable but neither were accepted. I'm trying to create an automation with a "Compare" module that is looped, generating a compare report per loop-cycle.

192 2 / Create an account to join the discussion.
dascott
Follow / 19 Feb 2018 at 3:53pm / Toad Data Point
Latest post by on 20 Feb 2018 at 10:45am

Change of Compare connection resets comparisons

Expand content
This issue is similar to, but different than, the issue in https://www.toadworld.com/products/toad-data-point/f/36/t/6948?pi11637=2 I'm running TDP 4.3.0.7.18 (64 bit). No matter what Data Compare...

This issue is similar to, but different than, the issue in https://www.toadworld.com/products/toad-data-point/f/36/t/6948?pi11637=2

I'm running TDP 4.3.0.7.18 (64 bit).  No matter what Data Compare connections I have, attempting to change the connection results in losing the comparison information. Rebuilding these comparisons takes about a half hour - I have over 200 tables to compare from a 400-table schema.

My comparisons are primarily between Oracle 12 and Postgres 9.5; comparing Oracle to Oracle or Postgres to Postgres (just changing the connection, not the technology) produces the same loss of function. Attempts to hack my way through by editing the XML of the .DCP file have not worked, either.

Please advise.

Thanks for your help!

144 1 / Create an account to join the discussion.