Examples of jdbc database URL for the different databases supported by Pure.

PostgreSQL

The PostgreSQL database URL consists of the name or IP of the server followed by the port, and name of the Pure database

jdbc:postgresql://localhost:5432/pure

Oracle

SID

jdbc:oracle:thin:@localhost:1521:SID

ServiceName

jdbc:oracle:thin:@//localhost:1521/ServiceName

MS SQL Server

We use the official Microsoft SQL Server JDBC driver, please refer to https://docs.microsoft.com/en-us/sql/connect/jdbc/building-the-connection-url?view=sql-server-2017 for complete details on how to build the connection string.

Normal

jdbc:sqlserver://localhost:1433;databaseName=pure

Instance Name

jdbc:sqlserver://localhost\instanceName:1433;databaseName=pure