Toad Data point 3.7 includes a redesigned and more robust version of the Transform and Cleanse tool. Please visit the ToadWorld Toad Data Point Community (http://www.toadworld.com/products/toad-data-point/b/weblog/archive/2015/03/20/toad-data-point-transformation-and-cleanse-part-1.aspx) for a video about this tool.
Note: SQL generation is currently only supported for Oracle and MySQL connections. For other database types, SQL is not generated and all rules display in red text.
Note: Publishing transformed data to Intelligence Central as a snapshot or view is currently only supported for Oracle and MySQL connections. However, you can publish transformed data from other data sources as a dataset.
Note: Applying a Format rule converts the target column to a string data type in the transformed data.
After modifying data, you can export or publish the transformed data, send the SQL to the Editor, or automate the transform and cleanse task. You can also save your work as a Toad Transform and Cleanse document.
Please note, Toad Data Point 3.7 still supports legacy Toad Transform and Cleanse documents (.tdc). The legacy Transform and Cleanse tool is retained in this release. The Cleanse Data automation activity also still supports legacy Toad Transform and Cleanse documents (.tdc).
You cannot publish a new Transform and Cleanse document (.tct) to Intelligence Central at this time. However, you can publish the transformed data.
See the new Transform and Cleanse tool in action! View the demo video to learn how to access and process data using the transformation and cleanse utility in Toad Data Point from Quest.