If you use JDBC client tools to query data from the Data Vault, such as a SQL tool or a third-party reporting tool, you must update the JDBC connection URL.

Use the following syntax for the JDBC connection string:

jdbc:infafas://<Data Vault administrator user>@<Data Vault hostname>:<Data Vault port>/<Data Vault database name>

Where

Data Vault administrator user
is the name of the default administrator user account that the client tool uses to connect to the Data Vault Service.
Data Vault hostname
is the name or IP address of the machine on which the Data Vault Service runs.
Data Vault port
is the port number of the machine that hosts the Data Vault Service.
database name
is the Data Vault database that contains the archived data. The database name is equivalent to the archive folder in Data Archive.

The following URL is an example of the required syntax for the JDBC connection string:

jdbc:infafas://dba@infa-server:8500/OPEN_MRS

Previously, the Data Vault supported JDBC driver type 2 connections with JDBC-based client tools.