Posted: 25 Nov 2018 23:18 EST Last activity: 18 Dec 2018 2:14 EST
In Pega tool how to connect external database, here have 7 operator ids, these all are working on same application. they create any datatype in tool , the data table is not showing in external database. so, how to implement it?
***Edited by Moderator: Pallavi to update platform capability tags***
When you run the first time BIX extract rule created, you will get an option to Generate DDL queries which will generate the CREATE TABLE statements. This sql file you need to run on the external database to create the tables. Once the tables are created in the external database, you can run the BIX extract rule to push the data in the required database.
Also, while generating the DDL queries, the schema name also would be appending in the statements. The default schema name you can modify in the JDBC url of the external database instance as currentschema=schemaname as a parameter if you are using postgres,db2 or orcale as an external database. But, if you are using SQL server as an external database, the default schema will be dbo, which can be altered only from SQL server.
Please let me know if this clarifies your query and resolves the issue.