How to connect to a Data Virtualization published data sources using DBVisualizer ?
book
Article ID: KB0071989
calendar_today
Updated On:
Products
Versions
TIBCO Data Virtualization
All Supported Versions
Description
Pre-requisites
1. Published View in TDV 2. SQL Client tool like DBVisualizer 3. TDV Server Credentials
Resolution
TIBCO Data Virtualization's published data sources can be accessed using several third party clients such as DBVisualizer, Squirrel and other SQL Clients.
For the purpose of this article we will be using DBVisualizer that provides a reliable way to connect to these data sources using a direct JDBC connection.
Configuring the JDBC Driver:
Open up the driver manager in DBVisualizer.
Click on the blue '+' sign and select the custom template.
Select a name for this adapter, set the url format to the following:
jdbc:compositesw:dbapi@<server name>:9401?domain=<domain name>&dataSource=<TDV published datasource name>
Click on the blue '+' sign in the right side, select add files and navigate to this path: TDV_Server_installation\apps\jdbc\lib , here select the csjdbc.jar file , if your TDV Installation is in another machine, navigate to the mentioned path and grab the csjdbc.jar file , place it anywhere in your current machine, DBVisualizer installation directory for example, and select it.
Confirm that the driver class field is populated with cs.jdbc.driver.CompositeDriver and close the window.
Setting up the server connection:
Create a new database connection and select the custom profile
On the connection properties window, change the name of the connection as need
In the database section, select Database URL as Settings Format and Database Type as Auto Detect.
In Driver Type, select the previously created driver, in database URL, please input the JDBC String of the server you're trying to access, in this example, we will use: