Search Knowledge Base by Keyword
-
Introduction
-
Fundamentals
-
My ReadyWorks
-
Analytics
-
-
-
- Available Reports
- All Asset Types
- Application Certification Status
- Application Discovery
- Application Group Analysis
- App Group to SCCM Collection Analysis
- Application Install Count
- Application License Management
- Application Usage
- Asset Column Mappings
- Asset Count by Property
- Asset Links Count by Asset Type
- Build Sheet
- Computer User Assignment
- Delegate Relationships
- ETL Synch Data
- ETL5 Staging Data
- Migration Readiness (Basic)
- Migration Readiness (Complex)
- O365 License Management
- O365 Migration Readiness
- Patch Summary
- SCCM OSD Status
- Scheduled Computers by Wave
- Scheduled Users by Manager
- User Migration Readiness
- VIP Users
- Wave & Task Details
- Wave Group
- Windows 10 Applications
- Show all articles ( 15 ) Collapse Articles
-
-
-
-
Orchestration
-
Data
-
-
- View Asset
- Asset Properties
- Images
- Notes
- Waves
- Tasks
- Attachments
- History
- Rationalization
- QR Code
- Linked Assets
- SCCM Add/Remove Programs
- Altiris Add/Remove Programs
- Related Assets
- Relationship Chart
- Permissions
- Show all articles ( 1 ) Collapse Articles
-
Integration
-
-
-
- View Connection
- Connection Properties
- Make Into Connector
- Delete Connection
- Inbound Jobs
- Outbound Jobs
- New Inbound Job
- New Outbound Job
- Enable Job
- Disable Job
- Edit Inbound Job
- Edit Outbound Job
- Upload File
- Run Inbound Job
- Run Outbound Job
- Set Runtime to Now
- Reset Job
- Delete Job
- Job Log
- Show all articles ( 4 ) Collapse Articles
-
-
- View Connector
- Connector Properties
- Authentication Methods
- New Authentication Method
- Edit Authentication Method
- Delete Authentication Method
- Fields
- Edit Field
- Inbound Job Fields
- Edit Inbound Job Field
- Inbound Job Templates
- New Inbound Job Template
- Edit Inbound Job Template
- Delete Inbound Job Template
- Outbound Job Fields
- Edit Outbound Job Field
- Outbound Job Templates
- New Outbound Job Template
- Edit Outbound Job Template
- Delete Outbound Job Template
- Show all articles ( 5 ) Collapse Articles
-
-
- ETL5 Connectors
- Absolute
- Azure Active Directory
- Comma-Separated Values (CSV) File
- Generic Rest JSON API
- Generic Rest XML API
- Ivanti (Landesk)
- JAMF
- JSON Data (JSON) File
- MariaDB
- Microsoft Endpoint Manager: Configuration Manager
- Microsoft SQL
- Microsoft Intune
- Oracle MySQL
- PostgreSQL
- Pure Storage
- ServiceNow
- Tanium
- XML Data (XML) File
- Show all articles ( 4 ) Collapse Articles
-
Admin
-
-
-
- Modules
- Attachments
- Bulk Edit
- Data Generator
- Data Mapping
- Data Quality
- ETL
- Form Builder
- Images
- Multi-Factor Authentication
- Notifications
- Rationalization
- Relationship Chart
- Reports
- Rules
- Single Sign-On
- T-Comm
- User Experience
- Show all articles ( 4 ) Collapse Articles
-
-
API & Stored Procedures
-
Administration
-
FAQs
Connection Settings
< Back
ReadyWorks connects to the ETL (Extract Transfer Load) to pull data into the ReadyWorks database from your data sources such as Active Directory, SCCM, Altiris and ServiceNow. The Connection Settings tab on the ETL 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
- 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
- Fields available
- Test the connection to the ETL database
Update Connection Settings
From the Connection Settings tab, you can update the ETL connection settings. To update:
- Enter a value for each connection setting
- Click the Update button to save your ETL connection settings