ETL

The ETL tab provides the ability to enable access to the ETL.

Available operations:

• Enable View, Create, Update, Delete, or Export access for the Connections page
• Enable View or Update access for the Connection Jobs page
• Enable View or Export access for the Job History page
• Enable View or Export access for the Staging Data page
• Enable View, Create, Update, Delete, or Export access for the Settings page
• Enable View, Create, Update, or Delete access for the Connector Library page
• Select all or deselect all permissions for the ETL
• Ignore attachments permissions from this Security Group

NOTE: The ETL module must be enabled to set permissions for the ETL.

Connections

View

From the ETL tab, you can enable View access for connections.

Available operations with View access:

• View the list of connectors and connections
• View the properties of connections
• View the error settings of connections
• View the list of inbound jobs of connections
• View the list of outbound jobs of connections

Create

From the ETL tab, you can enable Create access for connections.

Available operations with Create access (requires View):

• Activate new connections
• Install new connectors
• Make connections into connectors
• Create new inbound jobs
• Create new outbound jobs
• Run inbound jobs
• Run outbound jobs

Update

From the ETL tab, you can enable Update access for connections.

Available operations with Update access (requires View):

• Edit the properties of connections
• Edit the properties of connection jobs
• Edit the error settings of connection jobs
• Enable connection jobs
• Disable connection jobs
• Edit inbound jobs
• Edit outbound jobs
• Set the runtime to now for connection jobs
• Reset connection jobs

Delete

From the ETL tab, you can enable Delete access for connections.

Available operations with Delete access (requires View):

• Delete connections
• Delete connection jobs

Export

From the ETL tab, you can enable Export access for connections.

Available operations with Export access (requires View):

• Export the list of inbound jobs
• Export the list of outbound jobs

Connection Jobs

View

From the ETL tab, you can enable View access for connection jobs.

Available operations with View access:

• View the list of connection jobs

Update

From the ETL tab, you can enable Update access for connection jobs.

Available operations with Update access (requires View):

• Enable connection jobs
• Disable connection jobs
• Set the runtime to now for connection jobs
• Reset connection jobs

Export

From the ETL tab, you can enable Export access for connection jobs.

Available operations with Export access (requires View):

• Export the list of connection jobs

Job History

View

From the ETL tab, you can enable View access for job history.

Available operations with View access:

• View the job history of connection jobs

Export

From the ETL tab, you can enable Export access for job history.

Available operations with Export access (requires View):

• Export the job history

Staging Data

View

From the ETL tab, you can enable View access for staging data.

Available operations with View access:

• View the staging data

Export

From the ETL tab, you can enable Export access for staging.

Available operations with Export access (requires View):

• Export the staging data

Settings

View

From the ETL tab, you can enable View access for settings.

Available operations with View access:

• View the connection settings
• View the ETL settings
• View the list of ETL job schedules
• View the list of app filters (ETL4)
• View the SCCM widget goals (ETL3 or prior)

Create

From the ETL tab, you can enable Create access for settings.

Available operations with Create access (requires View):

• Create new ETL job schedules
• Create new app filters (ETL4)
• Import app filters (ETL4)

Update

From the ETL tab, you can enable Update access for settings.

Available operations with Update access (requires View):

• Update the connection settings
• Test the connection settings
• Update the ETL database
• Update the ETL settings
• Edit ETL job schedules
• Update the SCCM widget goals (ETL3 or prior)

Delete

From the ETL tab, you can enable Delete access for settings.

Available operations with Delete access (requires View):

• Delete app filters (ETL4)

Export

From the ETL tab, you can enable Export access for settings.

Available operations with Export access (requires View):

• Export the list of app filters (ETL4)

Connector Library

View

From the ETL tab, you can enable View access for the connection library.

Available operations with View access:

• View the list of connectors
• Download connectors
• View the properties of connectors
• View the list of authentication methods
• View the list of fields associated with authentication methods
• View the list of inbound job fields
• View the list of inbound job templates
• View the list of outbound job fields
• View the list of outbound job templates

Create

From the ETL tab, you can enable Create access for the connection library.

Available operations with Create access (requires View):

• Create new connectors
• Install new connectors
• Copy connectors
• Create new authentication methods
• Create new inbound job templates
• Create new outbound job templates

Update

From the ETL tab, you can enable Update access for the connection library.

Available operations with Update access (requires View):

• Edit the properties of connectors
• Edit the error settings of authentication methods
• Edit authentication methods
• Edit the fields associated with authentication methods
• Edit inbound job fields
• Edit the error settings of inbound job templates
• Edit inbound job templates
• Edit outbound job fields
• Edit the error settings of outbound job templates
• Edit outbound job templates

Delete

From the ETL tab, you can enable Delete access for the connection library.

Available operations with Delete access (requires View):

• Delete connectors
• Delete authentication methods
• Delete inbound job templates
• Delete outbound job templates

Select All

From the ETL tab, you can select all or deselect all permissions for the ETL.

1. From the menu in the upper right corner, check Select All to check (enable) all permissions on the tab.
   
2. Uncheck Select All to uncheck (remove) all permissions on the tab.
   

Ignore

From the ETL tab, you can ignore ETL permissions from this security group by selecting Ignore. This option is used when overlaying multiple security groups and ETL permissions are set by a different security group. Not enabling permissions on the ETL tab, without selecting Ignore, results in no access, as overlaid security groups assume the most restrictive permissions.