Question
aaseya it services pvt.ltd
SA
Last activity: 18 Sep 2019 0:43 EDT
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
Accepted Solution
Pegasystems Inc.
IN
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
Accepted Solution
Pegasystems Inc.
IN
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