JDBC URL syntax
This content applies only to On-premises and Client-managed cloud environments
If you want to use JDBC URL to connect to your external database, see below for the syntax used by different database types.
Pega Customer Decision Hub
Installation Guide
- Oracle
jdbc:oracle:thin:@<hostname>:<port>: <dbname>
- PostgreSQL
jdbc:postgresql://<hostname>:<port>/<dbname>
- MS SQL
jdbc:sqlserver://<hostname>:<port>;databaseName=<dbname>
- IBM Db2
jdbc:db2://<hostname>:<port>/<dbname>:fullyMaterializedLobData=true;
fullyMaterializeInputStreams=true;
progressiveStreaming=2;
progressiveLocators=2;
useJDBC4ColumnNameAndLabelSemantics=false;
currentSchema=<Marketing External Schema>;
resultSetHoldability=1;resultSetHoldabilityForCatalogQueries=1;allowNextOnExhaustedResultSet=1;
See below for an example of the syntax on IBM Db2. The database in the example is set to MYDB and the marketing external schema is set to MKTDATA.
jdbc:db2://localhost:50000/MYDB:fullyMaterializeLobData=true;
fullyMaterializeInputStreams=true;
progressiveStreaming=2;
progressiveLocators=2;
useJDBC4ColumnNameAndLabelSemantics=false;
currentSchema=MKTDATA;
resultSetHoldability=1;resultSetHoldabilityForCatalogQueries=1;allowNextOnExhaustedResultSet=1;
Previous topic JNDI name syntax Next topic Importing the application bundles