Question
Tech Mahindra
IN
Last activity: 18 Dec 2018 2:14 EST
external database
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***
Pegasystems Inc.
IN
Hi Bhavani,
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.
Accepted Solution
Instellars Global Consulting Pvt. Ltd.
IN
If you want to connect external DB and want to use those table. Follow below steps:
1. Goto Records Explorer-->SysAdmin--> Database--> Create Database rule for external table
Specify JDBC Url, Username and Password of that DB.
2.Goto Records Explorer-->SysAdmin--> Database table--> create specify name and Select class which you want to map to internal pega class.
--->select Database which you have already created.
---> Specify database table which you want to use from external Database.
3. Now you can use pega class which you have mapped to external table.