Question

Path need to give in ddl in extract rule

What is the path need to give in ddl file name in extract rule when database schema is selected as configuration

Correct Answer
September 16, 2019 - 5:38pm

Hi Mounika,

When you select Database Schema as target for BIX extract, before extracting data to the target database you must first create a schema to match the extracted data. You can use BIX to generate an SQL file that creates the appropriate schema. For this ddl file name and path option. You can give the path which can be accessed by pega and when you run the extract rule you will get a button to generate DDL. When you click this button then the DDL will be generated in the path specified. You need to run this SQL in the DB to create appropriate table.

Regards,

Vikash

Comments

Keep up to date on this post and subscribe to comments

Pega
September 16, 2019 - 9:08am

Hi,

Could you please provide us the snapshots of your configuration.

Thank you,

September 16, 2019 - 5:38pm

Hi Mounika,

When you select Database Schema as target for BIX extract, before extracting data to the target database you must first create a schema to match the extracted data. You can use BIX to generate an SQL file that creates the appropriate schema. For this ddl file name and path option. You can give the path which can be accessed by pega and when you run the extract rule you will get a button to generate DDL. When you click this button then the DDL will be generated in the path specified. You need to run this SQL in the DB to create appropriate table.

Regards,

Vikash

September 18, 2019 - 12:43am
Response to Vikash Karn

ThankYou