Search Knowledge Base by Keyword

Overview

< Back

The ETL module allows you to connect to your data sources and synchronize your data into the ETL, where you can then aggregate your data sources into a consolidated view in ReadyWorks, and orchestrate outbound actions.  The following sections detail the functionality of the ETL.

ETL Features

Connections View and activate connections to your data sources
Connection Jobs View and manage jobs for all connections
App Filters View and create app filters
Connection Settings View and configure ETL connection settings
Other Settings View and configure ETL job runtime settings
Error Settings View and configure ETL job error settings
ETL Job Schedules Manage ETL job schedules
Connectors View and configure connectors to your data sources
SCCM Widget Goals Set goals and thresholds for the widgets on the SCCM Asset dashboard

Below is a diagram of a typical ReadyWorks setup and the associated data flows.

The ReadyWorks ETL interfaces with various on-premises and hosted systems in your environment.  Example connectors include:

  • Active Directory (LDAP/AD)
  • System Center Configuration Manager (SCCM)
  • ServiceNow
  • Okta
  • Azure AD
  • O365 Tenants
  • SharePoint Foundation
  • Jamf MDM
  • Altiris
  • 3rd Party REST APIs
  • Microsoft SQL Databases
  • MySQL Databases
  • Oracle Databases
  • CSV Files

NOTE: A list of some of the latest connectors available in ReadyWorks is outlined in the ETL5 Connector Library.