Start the ETL Validator by double-clicking the desktop icon or by searching for the ETL Validator in Windows Programs. The ETL Validator opens and displays the Login page. Enter User Name, Password, Repository, and click Sign In.
- Before logging in to ETL Validator, ensure that you are connecting to the correct repository.
- You will need to enter your LDAP credentials if your ETL Validator administrator has integrated the application with an LDAP directory. If your are not sure about your credentials, please check with your ETL Validator administrator.
If you are not sure which repository to connect, please check with your ETL Administrator. If you want to understand how to create, import, and export a respository connection, please see the sections below.
Create a Repository Connection
All users logging in to ETL Validator must connect to a correct repository to ensure their Test Plans data is accessible. You can create either an Oracle or PostgreSQL database as repository. Please note that data in one repository cannot be accessed by logging in to ETL Validator, with another repository.
If you already have the repository connection file and want to create a repository, see Import a Repository Connection.
To create a repository,
On the Log In page, click the Add (+) icon.
In the Repository Details screen that opens, complete the following details for Oracle/PostgreSQL database:
- Respository Name. Specify a name to the respository. This field is read-only if you are editing the existing repository.
- Database Type. Select a database from the drop-down list. Supported databases are PostgreSQL and Oracle.
- User Name. Enter a username for the repository.
- Password. Enter a password for the user.
- Host. Specify a host name of the repository.
- Port. Specify a port number of the repository.
- SID (Oracle only). Enter the system Id of the Oracle database.
- Service Name (Oracle only). Enter the service name of the database.
- Driver Type (Oracle only). Select a driver type from the drop-down list. Available types are Direct and Oracle_Call_Interface. Select any one of the following:
- Direct. This is a type 4 driver that converts JDBC calls into a network protocol that sends the converted packets to be used directly by the Oracle database. Thus, allowing a direct call from the client machine to the DBMS server.
- Oracle_Call_Interface. The OCI driver is a type 2 JDBC driver and uses native code to connect to the database. Thus, it is only an option on platforms that have native drivers available.
- Database Name (PostgresSQL only). Enter a name of the database.
Click Test to verify whether the connection is successful.
Click Save to save the repository connection details.
Export a Repository Connection
If you want to share the repository connection details with other users, you can do so by exporting the repository connection that you are already using it to connect to the ETL Server. Below are the steps to export a repository connection:
- On the Log In page, click the Export icon.
- Browse and select the folder location where the file should be created.
- Click OK. The repository connection file is created.
Importing a Repository Connection
If your administrator has shared the repository connection file, follow the steps below to create a repository connection:
- On the Log In page, click the Import icon.
- Search and select the repository file, and click Open.
The repository connection is created and you should now see the repository is available for selection in the Repository drop-down list.
© Datagaps. All rights reserved.
Send feedback on this topic to Datagaps Support