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!
Using Toad Data Point 184.108.40.2068 (32 bit) and Toad Intelligence Central 220.127.116.11. 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.
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.
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 18.104.22.168.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.
Thanks for your help!