![]() Database UserId: The username to use to authenticate to DB2.Jdbc:db2:Server=10.0.1.2 Port=50000 User=admin Password=admin Database=test This will limit the number of rows returned, which is especially helpful for improving performance when designing reports and visualizations. When you configure the JDBC URL, you may also want to set the Max Rows connection property. 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. The syntax of the JDBC URL is jdbc:db2: followed by the connection properties in a semicolon-separated list of name-value pairs.įor assistance in constructing the JDBC URL, use the connection string designer built into the DB2 JDBC Driver. Driver: Select the driver you just created.ĭatabase URL: Enter the full JDBC URL.If you selected the "No Wizard" option, select the Generic or Auto Detect option in the Database Type menu. Database Type: If you selected the wizard option, the database type is automatically detected.In the Connection section, set the following options: In the Database tab, right-click the Database Connection node and click Create a Database Connection. ![]() In the Driver Class menu, select the DB2Driver class, 2Driver.ĭefine the Connection to the JDBC Data Sourceįollow the steps below to save connection properties in the JDBC URL. ![]() For more information on how to write and run queries, please read the guide on query execution.In the User Specified tab, click the Open File button and select the file, located in the lib subfolder of the installation directory. Now that you have connected DbVisualizer with Query Service, you can use DbVisualizer to write queries. A message appears in the log to confirm a successful connection. The Connect dialog appears on the first occasion of the session.Įnter your Userid and Password and select Connect. The Userid will be in the format of Database Password: This is an alphanumeric string found on the Query Service credentials dashboard.Īfter you have input all relevant credentials, select Connect. Database Userid: This is your Platform Organization Id.Database: Use the credential dbname value prod:all.You must use port 80 to connect with Query Service. Database Port: The port for Query Service.Database Server: This is your Experience Platform Host credential.Name: You are recommended to provide a friendly name to recognize the connection.To make a connection, select the Connection tab from the Database Connection workspace and enter your Experience Platform credentials for the following settings. In the Connection Authentication panel, check both the Require Userid and Require Password checkboxes then select Apply. To require a user ID and password-based authentication each time a connection is established, select Authentication from the navigation sidebar under PostgreSQL. The Edited column shows a checkmark to denote that the parameter value has been updated. It is an alphanumeric string ending in add a second user profile, select user from the parameter column then select the blue + (plus) icon to add credentials for each user. The username connected to the database is your Organization ID. You must use the value “1” to enable this requirement. This controls the use of SSL requirements. This value is your Experience Platform Host credential. The three required driver properties are seen in the table below. The Database Connection workspace appears.įrom the Database Connection workspace, select the Properties tab, followed by the Driver Properties from the navigation sidebar. Use the search bar or select PostgreSQL from the driver name dropdown list. Then select Create a Connection in the panel to the right. Once you have installed the desktop app on your local machine, start the app and select Create a Database Connection from the initial DbVisualizer menu. Please contact your IMS Organization administrator if you do not currently have access to the Queries workspace. ![]() To acquire the necessary credentials for connecting DbVisualizer to Experience Platform, you must have access to the Queries workspace in the Platform UI. There may be minor discrepancies in the UI between the versions. Screenshots in this guide were taken using the macOS desktop app. There are Windows, macOS, and Linux versions of DbVisualizer.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |