Table of Contents

Search

  1. Version 6.4.3
  2. Version 6.4 HotFix 2
  3. Version 6.4 HotFix 1
  4. Version 6.4
  5. Version 6.3
  6. Version 6.2 Hot Fix 2
  7. Version 6.2 Hot Fix 1
  8. Version 6.2
  9. Version 6.1.1
  10. Version 6.1

Connectivity

Connectivity

Effective in version 6.2, client tools that use JDBC drivers to the connect to the Data Vault must use JDBC driver type 4.
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.