Either double-click the JAR file or execute the jar file from the command-line.įill in the connection properties and copy the connection string to the clipboard. If the Database property is not specified, the data provider connects to the user's default database.įor assistance in constructing the JDBC URL, use the connection string designer built into the PostgreSQL JDBC Driver. To connect to PostgreSQL, set the Server, Port (the default port is 5432), and Database connection properties and set the User and Password you wish to use to authenticate to the server. The JDBC URL begins with jdbc:postgresql: and is followed by a semicolon-separated list of connection properties.
Enter the username, password, and JDBC URL. On the next page, set the Authentication Mode option to "Use specified username and password".
On the next page of the wizard enter the connection details.In the wizard that results, click Generic -> Generic JDBC datasource -> JDBC Drivers.Right-click your project and click New -> New Relational Connection.The CData JAR is located in the lib subfolder of the installation directory. lic file into the following subfolder in the installation directory for BusinessObjects: dataAccess\connectionServer\jdbc\drivers\jdbc. You will then connect to the universe from Web Intelligence.įollow the steps below to create a connection to the PostgreSQL JDBC data source in the Information Design Tool. You will use the Information Design Tool to analyze PostgreSQL data and create a universe on the CData JDBC Driver for PostgreSQL.
#Java no suitable driver found for jdbc postgres how to#
This article shows how to use the CData JDBC Driver for PostgreSQL to connect to PostgreSQL from SAP BusinessObjects Business Intelligence applications.
0 kommentar(er)
