How to Configure a Generic JDBC Connection
To configure a connection to a generic JDBC database, follow these steps:
- Open the Preferences dialog box and go to Data Sources.
-
Click the
New button in the Connections panel.
- Enter a unique name for the connection.
- Select the Generic JDBC data source in the Data Source drop-down menu.
-
Enter the connection details.
-
Enter the URL of the generic JDBC database, with the following
format:
jdbc: <subprotocol>: <subname>. - Enter the user name for the connection to the generic JDBC database.
- Enter the password for the connection to the generic JDBC database.
-
Enter the URL of the generic JDBC database, with the following
format:
- Click the OK button to finish the connection configuration.
- To view your connection, go to the Data Source Explorer view (if the view is not displayed, it can be opened by selecting it from the menu) or switch to the Database perspective.