Salesforce

Supported JDBC URL Format (Magic xpi 4.14)

Printable View
« Go Back

Information

 
Created BySalesforce Service User
Approval Process StatusPublished
Objective
Description

Supported JDBC URL Format (Magic xpi 4.14)

Note that given below is a sub-set of URLs and not a comprehensive list. For the complete list of supported URLs, check the product documentation.

MSSQL

  • jdbc:sqlserver://[Host]:[Port];databaseName=[DatabaseName]

  • jdbc:sqlserver://[Host]:[Port];databaseName=[DatabaseName];integratedSecurity=true

  • jdbc:sqlserver://[Host]:[port];databaseName=[DatabaseName];user=[UserName];password=[Password]

MySQL

  • jdbc:mysql://[Host]:[Port]/[DatabaseName]

  • jdbc:mysql://address=(host=[Host])(port=[Port])(user=[UserName])(password=[Password])/[DatabaseName]

  • jdbc:mysql://[Host]:[Port]/[DatabaseName]?user=[UserName]&password=[Password]&characterEncoding=[Encoding]

Oracle

  • jdbc:oracle:thin:@[Host]:[Port]:[SID]

  • jdbc:oracle:thin:[User]/[Password]@[Host]:[Port]:[SID]

  • jdbc:oracle:thin:@//[Host]:[Port]/[Service Name]

  • jdbc:oracle:thin:[User]/[Password]@//[Host]:[Port]/[Service Name]

DB2400/AS400

  • jdbc:as400://[Host]/[DatabaseName]

PostgreSQL

  • jdbc:postgresql://[Host]:[Port]/[DatabaseName]?user=[UserName]&password=[Password]

  • jdbc:postgresql://[Host]:[Port]/[DatabaseName]

DB2

  • jdbc:db2://[Host]:[Port]/[DatabaseName]

  • jdbc:db2://[Host]:[Port]/[DatabaseName]:user=[UserName];password=[Password]

PostgreSQL and DB2 databases are not verified for the JDBC resource.

Reference
Attachment 
Attachment