Load Connector Details Advanced Job

This document will provide a step-by-step guide for executing the “Load connector details” advanced job, which helps create multiple SQL Server connections.

The OvalEdge team will provide an XLSX file where the below fields are required.

connType - RDBMS
Authentication - SQL Server Authentication / Windows Authentication
OvalEdge Installed Environment - Empty for SQL Server Authentication and Windows for Windows Authentication
Credential Manager - OE Credential Manager
isAutoLineageConnector - 0/1
isDataQualityConnector - 0/1
isDataAccessConnector - 0/1
Connection Name - Provide the desired name
EnvironmentType - Empty
Server - Provide the server details
Port - The default one for the SQL server is 1433
sid(database name) - Testdb
driver-com.microsoft.sqlserver.jdbc.SQLServerDriver
Username -
Password -
Connectionstring - Empty
Pluginport - Empty
Steward - Enter the desired one
Custodian - Enter the desired one
Owner - Enter the desired one
Integration_admin - Enter the desired one
Security and governance admin - Enter the desired one
No of Archived objects - 0/1
BridgeId - 0/1

Sample Spreadsheet Screenshot

This XLSX file needs to be placed in a separate folder.

Example: D:\Americo\Inputsqlserver2.xlsx

Download the jar Download Encryption Jar File and place it in the same folder where we have the input file.
Now, generate the new output file where we will have the passwords encrypted.

Note:- Please refer to the "Additional Information" section for the steps to generate the encrypted file.

Once the encryption is completed, it will generate a new file with the password encrypted.

The OvalEdge Team will provide another XLSX file to enable the Crawler options. We need to place the spreadsheet in the same folder as the input and output files.

How to Run the Job

Navigate to the Administration > Advanced Jobs module, and the list of Advanced Jobs in the OvalEdge will be displayed.
In the Name column field, enter the Advanced Job name and click enter. The related advanced jobs are displayed.
Select the checkbox for the Load Connector Details advanced job, and in the Attribute column field, click on the edit icon. The Edit Advance Job pop-up window will then appear.
In Attribute 1, provide the File location for the output and extension files.
Ex: D:\Americo\sqlserveroutput.xlsx
In Attribute 2, provide the secret key provided during an encryption key generation.
Ex: ovaledge
In Attribute 3, provide the path for the crawler options and the extension.
Ex: D:\Americo\crawleroptions.xlsx
Click on the button. The entered details are saved in the Attributes column.
Click on the button, and a confirmation message will appear to run the advance job.
Note: The Run Advance Job button is only enabled if the Advanced Job checkbox is selected.
Click on the Submit button, and a prompt message will appear indicating whether the Job is a success, an error, or a Partial success.
- Success: Job completed without any errors.
- Error: Job terminated with an error.
- Partial Success: Job completed with errors.

Additional Information

Generating Password for Encrypted XLSX File

Securing sensitive data is important for keeping information safe. In this guide, we'll show you how to create a password-protected XLSX file using an encryption tool.

Prerequisites

Internet Connection: Ensure you have a stable internet connection to download the encryption Jar file and necessary tools.
Java Installed: Make sure Java is installed on your computer. You can check it by typing "java -version" in the command prompt and pressing Enter. If not installed, download and install Java from the official website.
Access Permissions: Ensure you have the necessary permissions to create folders, download files, and run commands on your computer.

Securing Excel File

Step-by-Step Guide to Encryption:

Just follow these steps to make sure your Excel file stays secure:

Step 1: Download the EncryptionJar

Click on the link to download the encryption Jar: [Encryption Jar] Download Encryption Jar File

Step 2: Locate the Downloaded File

After downloading, create a new folder and put the Jar in it.

Step 3: Check Java Version

Open Command Prompt and type java -version then press Enter to make sure Java is installed and working.

Step 4: Run the Encryption Jar

Use this command: "java -jar EncryptFilePassword.jar"

Step 5: Provide File Paths

Follow the prompts to enter the path of your Excel file and the place where you want to save the encrypted file.

Step 6: Enter Encryption Key

When asked, type a secret key for encryption. Remember this key for decryption and update it in the OvalEdge environment.

Step 7: Complete Encryption

After entering the key, the tool will encrypt the passwords and save the file where you specified. Share the encrypted file with the OvalEdge team.

Keep the secret key safe and update it in the OvalEdge environment.