Creating and updating external database instances with JDBC URLs
Specify a JDBC URL to create a database data instance so that Pega Platform can access a supported external database. Pega Platform is optimized to connect to external databases via JDBC URLs.
When you deploy on Pega Cloud services environments, use JDBC URLs to define external database instances which your application uses to access and manage connections to that database.
To deploy on-premises or client-managed cloud systems, use JDBC connection pools. For more information, see Creating database instances for JDBC connection pools.
- In the header of Dev Studio, click .
- Enter a short description, and in the Database field,
enter a name for the additional database. The database name is case-sensitive.
- Click Create and open. The Edit <YourNewDatabaseName> Database page appears.
- Optional: To indicate the system of record, in the Integration
system field, press the Down arrow key and select the name of
the integration system to associate with this database.The value that you select is for informational purposes only, and does not affect the behavior of the database instance. You can use this value to organize rules for integration connectors, data types, and sources for data pages.
- In the How to connect list, click Use JDBC URL listed below.
- In the JDBC URL field, enter the JDBC URL.The format of the JDBC URL depends on the database platform. Precise syntax requirements and parameters vary depending on the server platform, database version, and JDBC client. Consult your database administrator for details.
- In the Authentication
section, add the required and any optional credentials for the external database
connection.
- To add standard users, In the Username field,
enter the name of a database user who has read and update permission,
and in the Password field, enter the password for
that user.Specify a user that is capable of accepting unqualified table names and converting them to fully qualified table names. If this database is to be accessed through Connect SQL rules, confirm that this database user has search, update, delete, and other permissions that support the SQL statements in those rules, and that this database is the default database of the user.
- Optional: To add users with Administrator permissions, in the Admin
username field, enter the name of a database user who
has permission to alter and create tables, and in the Admin
password field, enter the password for that user.The admin user is used to configure tables that extend the Pega data schema. The admin user is used for platform-generated schema changes, property optimization, Query Inspector, Query Runner, Schema Tools, and circumstance definitions.
- Optional: To add users with read-only permissions, in the Read-only username field, enter the name of a database user who has read-only permission, and in the Read-only password field, enter the password for that user.
- To add standard users, In the Username field,
enter the name of a database user who has read and update permission,
and in the Password field, enter the password for
that user.
- Click Save.
- Optional: To specify connection pool parameters and test connectivity to your database, click the Advanced tab.
- Leave the Connection count limit field blank. It is reserved for future use.
- Leave the Failover options fields blank. They are reserved for future use.
- Optional: On the Advanced tab, specify the names of other database
instances that should be reachable by views in this database.
- Under the Database Name list, click the Add item icon.
- In the Database Name field, press the Down arrow key, and select the name of a database instance that views in the external database need to access.
- Click Save.
- To test the database connection, on the Database tab,
click Test connection.
- If the test fails, diagnostic information appears in a new window. Modify the database instance until the test succeeds.
- This test does not test the administrative user, if any, that you might have specified.
- Configuring connectivity parameters for an external Pega Platform database
External database connections through a Java Database Connectivity (JDBC) URL are managed by Pega Platform and use connection pools to handle connection traffic. You can modify the default parameters of the connection pools to limit or increase connections, edit their timeout value, and create a new schema name for each database user to optimize connectivity for your external database connection. You can also request to add additional connectivity parameters specific to your external database vendor through My Support Portal.
Previous topic Creating database instances for prconfig references Next topic Configuring connectivity parameters for an external Pega Platform database