Skip to content


Using the Provisioning on Hire2Retire you can provision and deprovision users on Fivetran Read the official documentation of Fivetran here.

Fivetran Application on Hire2Retire

Figure 1. Fivetran Application on Hire2Retire

Define Role Definition

Provisioning Type

Define Role(s)

You can assign a Role to any user based on their AD attributes. You can define complex conditions using AND and OR logic. You can also use the Group memberships in AD to define Roles. The Roles are used to assign specific priviliges and licenses in Fivetran. For Example: In Figure 2, the rules are defined on the basis of Department (Equals). If the rules are passed then only user(s) will get provisioned. If no rule passes and the user(s) is present in Fivetran then deprovisioning is performed for the user(s).

Fivetran ScimManager Table1

Figure 2. Provision users with following rule definitions

Map the rules defined in first table with the Roles set(s) provided by Fivetran.

  • Roles in Fivetran are a way to group together users who have similar responsibilities. They are used to define the permissions and responsibilities of a specific role in an organization, rather than the permissions and settings of a specific group of users.

Fivetran ScimManager Table2

Figure 3. Role to License Mapping

You can also select default roles in Fivetran. For if and only if 'Developer' Role is passed and it is not mapped in the second table then the selected default Profile, Role in Fivetran and Permission Set(s) will be assigned to the user(s).

Fivetran ScimManager Default Roles

Figure 4. Default Role in Fivetran to add to rest roles

Process All Employees

All user(s) will be provisioned on Fivetran.

Fivetran Process All Employees

Figure 5. Process All Employees

Provision User

You can decide to either provision or deprovision using Provisioning.

You can provision one or more user(s) according to the requirement. User(s) can be created, updated or reactivated in provisioning operation. You can deprovision one or more user(s) according to the requirement. User(s) can be terminated in deprovisioning operation.

Fivetran Form Operations

Figure 5. Configure lifecycle operations for Fivetran

Map attributes on Fivetran

You can select the attributes provided by Fivetran that you want to populate. You can map values from AD/AzureAD/Hybrid to populate these attributes. You can also use Hire2Retire's powerful data transformation capabilities using Excel Style functions.

Fivetran Form Attributes

Figure 7. Select Fivetran attributes