JobManipulator for DataStage
WHAT SETS US APART?
The conversion process is controlled by a config-file with the necessary settings.
- Filter reading and writing stages using (to) SQL schema-names. Use different settings for read or writing stages.
- Set settings for the Snowflake Connector Stage by set, copy and adjust settings Oracle.
- Change text within an ISX-file, a job or a stage
- Rename Stages (like changing the prefix from ORA_ to SNOW_)
Adjust Parallel Jobs and Shared Container for Snowflake
- The Snowflake Connector Stage does not support rejects-links. The JobManipulator removes reject links and or directly dependent stages.
- Before and after SQL can be changed, cleared or set.
- Handle Partitioned Read and Runtime Column Propagation for reading stages
- To improve INSERT/UPDATE/DELETE performance of generated SQL-statements in Snowflake use Merge-mode provided with DataStage V11.7.1.1 (using Snowflakes INTERNAL STAGES)
- Support new parameter “Max files size” of the Snowflake Connector Stage introduced by PMR JR62815 to support large temporary files
Provides mechanism to change SQL-statements to adapt the different SQL-dialects of Oracle and Snowflake
- Change functions calls
- Convert text using regular expressions
- Adjust operands for the concat-operator || for differing NULL-handling of Oracle and Snowflake
WHAT BENEFITS DO I HAVE AS A CUSTOMER?
Focus on the strategical aspects of your migration process – reduce boring manual steps
- Save time. Avoid to do the manual, tedious and error prone steps to change the stage from Oracle to Snowflake
- Concentrate on the “How to” change my DataStage projects.
Be agile. Gain speed with the highly automated conversion process
- Start small with a limited number of jobs.
- Adjust the settings and re-run the conversion process if needed.
- Convert the whole project multiple times in a minute.
- Reduce manual changes to a minimum.
