meta data for this page
  •  

This is an old revision of the document!

Setup menu > Application

Databases

This settings tab lists all databases known to Vigilens.

Add a database

SQL Language used

Vigilens natively supports the SQL language for the following platforms:

  • Access
  • DB2/400 except Union
  • DB2/Windows except Union
  • MySQL
  • Oracle
  • SQL Server

Data source

Oracle

For Oracle databases, connection is made through OCI, only TNS service name has to be provided.

In some machine configurations, the OCILIB library does not initialize correctly because the Windows user environment variables do not allow to locate the oci.dll file (present in the Oracle installation directory).
NB : this is often the case for the web server due to Windows account binded to web service.

It is then possible to define this path via a registry key: HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\EVIDENS\Param\OracleLibPath
(HKEY_LOCAL_MACHINE\SOFTWARE\EVIDENS\Param\OracleLibPath for 32 bits machines)

ODBC

Otherwise, the connection is made through ODBC.

You must then choose (with the wizard) one of the ODBC connections defined either at the user level or at the system level. In most cases, we will use a system source.

In the case where the data source is not created in ODBC, you can access the windows ODBC setup by clicking ODBC data source setup button.

On 64-bit systems, it is advisable to use this button to access ODBC data source administration. This is because the application uses the 32-bit version of ODBC while the administration tools allow access to the 64-bit version.

Connection

Database type

Allows you to specify the JDE version to ensure the correct reading of the data.

Data source name

Type here the description that will appear everywhere in Vigilens.

Advanced Setup

Global

Files

Attachement

Share

Once defined, a data source must be shared in order to be accessed by all Vigilens users.

Help box

Global

Set user

Database for export