ReadyWorks connects to the ETL (Extract Transfer Load) to pull data into the ReadyWorks database from your data sources such as Active Directory, ServiceNow, VMware, and Intune. The ConnectionSettings tab on the Settings page provides the ability to view, configure, and test connectivity between ReadyWorks and the ETL.

Available operations:

• View and update the ETL connection settings
  • Fields available
    • Use Core Database Connections – Check to use the core database connection configuration
    • SQL Server Name – Hostname of the ETL database server
    • Port Number – Port used to connect to the ETL database
    • Username – User account used to connect to the ETL database
    • Password – Password of the user account used to connect to the ETL database
    • DB Name – Name of the ETL database
• Test the connection to the ETL database
• Check for connection errors to the ETL database
• Update the ETL database schema

Update Connection Settings

From the Connection Settings tab, you can update the ETL connection settings. To update:

1. Enter a value for each connection setting
2. Click the Update button to save your ETL connection settings

Test Connection

From the Connection Settings tab, you can test the connection to the ETL. To test the connection:

1. Click the Test Connection button
2. The following status message is displayed when a connection is successfully established
   
3. The following status message is displayed when an error occurs establishing the connection
   

Connection Error

Connection errors are displayed when ReadyWorks is unable to connect to the ETL.

1. The Connection Settings tab will be marked . ETL pages are unavailable when the connection is disconnected.
   
2. When the connection is reestablished, the Connection Settings tab will be marked 

Update ETL DB Schema

From the Connection Settings tab, you can update the ETL database schema. To update:

1. Click the Update ETL DB button
2. The following status message is displayed when the ETL database schema is updated successfully