Integrate FiveTran

FiveTran is cloud-based data movement platform (see https://www.fivetran.com/). You can protect access to FiveTran by integrating FiveTran with Identity as a Service. Once integrated, users can use single sign-on to log in to their FiveTran account through Identity as a Service.

Note: This integration was tested using Identity as a Service version 5.31 and FiveTran version July 2023. Other versions of FiveTran may require integration and configuration steps that differ from those documented in this procedure. For other versions of FiveTran, this integration guide may be used as an initial approach for integrating FiveTran. In the event of other issues, contact support@entrust.com for assistance.

To integrate FiveTran with Identity as a Service, you must do the following:

Before you begin, open two browser windows. In one window, log in to your FiveTran administrator account. In the other window, log in to your IDaaS administrator account.

Step 1: Copy the SAML configurations from Identity as a Service

Copy the SAML Configuration from Identity as a Service

1. Log into your Identity as a Service administrator account.

2. Click > Security > Applications. The Applications Lists page appears.

3. Under SAML Cloud Integrations, click SAML Configuration. The SAML Configuration dialog box appears.

This dialog box contains information you need to configure your SAML application for Identity as a Service authentication.

4. Do one of the following:

● Leave this dialog box open to reference later in this procedure.

● Copy the Entity ID, Single Sign-on URL, and Single Logout URL to a text file and save it to reference later in this procedure.

Note: Depending on the integration you are performing, you may not need all three of these SAML configuration values.

Step 2: Copy the SAML signing certificate from Identity as a Service

Copy a SAML signing certificate

1. Log in to your Identity as a Service administrator account.

2. Click > Security > Applications. The Applications List page appears.

3. Under SAML Cloud Integrations, click SAML Signing Certificates. The SAML Signing Certificates page appears.

4. Click next to the certificate to copy it to the clipboard.

You can additionally download the certificate and save it for future use.

5. Open a text editor, such as Notepad, and paste the contents of the certificate into the text file.

6. Save the file.

Note: Be sure to same the file with the .cer extension, for example, SAML_certifcate.cer.

Step 3: Configure FiveTran for Identity as a Service authentication

1. Log in to FiveTran. The FiveTran page appears.

2. Click > Account Settings. The Account Settings options appears.

3. Click General. The Settings page appears.

4. Under Settings, click the Account Settings tab.

5. Scroll to SAML Config.

6. Toggle Enable SAML authentication to ON.

7. In the Sign on URL, enter the Single Sign-ON URL that you copied in Step 1: Copy the SAML configurations from Identity as a Service.

8. In the Issuer, enter the Entity ID URL that you copied in Step 1: Copy the SAML configurations from Identity as a Service.

9. In the Public Certificate field, paste the certificate you copied in Step 2: Copy the SAML signing certificate from Identity as a Service.

10. In the Application identifier (Entity ID) field, enter a valid Entity ID value, for example, FiveTran.

11. Click Save Config.

Step 4: Add FiveTran to Identity as a Service

1. In Identity as a Service, click > Security > Applications. The Applications Lists page appears.

2. Click Add. The Select an Application Template page appears.

3. Do one of the following:

● Select SAML Cloud Integrations from the search drop-down list and scroll to find the application you want to add to IDaaS.

- or -

● In the Search bar, enter a search option to filter for the application you want to add to IDaaS.

4. Click FiveTran. The Add FiveTran page appears.

5. Enter an Application Name.

6. Enter an Application Description.

7. Optional. Add a custom application logo.

a. Click next to Application Logo. The Upload Logo dialog box appears.

b. Click to select an image file to upload.

c. Browse to select your file and click Open. The Upload Logo dialog box reappears showing your selected image.

d. If required, resize your image.

e. Click OK.

8. Select the Authentication Flow that appears to users during login.

9. Click Next. The General page appears.

10. In the Default Assertion Consumer URL field, enter:

https://fivetran.com/login/return

11. In the Service Provider Entity ID field, enter:

FiveTran

12. Leave the Single Logout Service URL empty.

13. Enter the SAML Session Timeout to the time when the SAML Assertion times out. The maximum is 720 minutes.

14. Enter the Max Authentication Age (seconds) to set the maximum amount of time that can elapse before a user is required to reauthenticate during a new login attempt. This applies for both SP-initiated and IDP-initiated login. Set this field to -1 to disable this feature.

15. From the SAML NameID Attribute drop-down list, select Email.

16. From the SAML NameID Encoding Format drop-down list, select Email.

17. From the SAML Signing Certificate from the drop-down list, select the SAML Signing Certificate you added to FiveTran in Step 3: Configure FiveTran for Identity as a Service authentication.

18. From the SAML Signature Algorithm drop-down list, select SHA512.

19. Select Sign Complete URL Response.

20. Optional: Select Respond Immediately for Unsuccessful Responses to return to the application immediately after a login failure, rather than allow user to try again with a different userID.

21. Deselect Enable Go Back Button if you do not want users to be able to go back to the FiveTran login page to log in.

22. Select Show Default Assertion Consumer URL Service in the My Profile. When selected, the Default Assertion Consumer URL appears in a user's My Profile page in addition to relay states and Alternative Assertion Consumer URLs.

23. Optional. Add Alternative Assertion Consumer Service URLs, as follows:

a. Click Add.

b. Enter a Name.

c. Enter a URL Value.

d. Select Show in My Profile to display the Alternative Consumer Service URL in a user's My profile page.

e. Optional. Add an Application Logo.

f. Click Add.

g. Repeat these steps to add more Alternative Assertion Consumer Service URLs.

24. Add SAML attributes as follows (you need to add two attributes):

Add the First Name attribute, as follows:

a. Under SAML Attributes, click Add. The SAML Attributes dialog box appears.

b. In the Name field enter FirstName

c. Click Add next to Value(s).

d. In the Values field, type < and select First Name.

e. Click Add.

Add the Last Name attribute, as follows:

a. Under SAML Attributes, click Add. The SAML Attributes dialog box appears.

b. In the Name field enter LastName

c. Click Add next to Value(s).

d. In the Values field, type < and select Last Name.

e. Click Add.

25. Leave the remaining settings at the default values.

26. Click Submit.

Step 5: Add a resource rule

Step 6: Test the integration

Note: If you assigned the FiveTran app to a user who does not have a corresponding FiveTran user ID, you need to grant the user write access after they have been automatically provisioned in your Fivetran account. See https://fivetran.com/docs/getting-started/fivetran-dashboard/account-management/sso/pingone-saml-sso#infivetran

Testing Service Provider Login

1. Open a Web browser and enter the URL for your FiveTran account.

2. Click Login. You are redirected to the FiveTran login page.

3. Enter the FiveTran account email address. If single sign-on is enabled, the password is hidden.

4. Click Continue.

5. Respond to the second-factor authentication challenge. If you respond successfully, you are logged in to FiveTran.

Testing Identity as a Service redirect log in

1. Log in to your Identity as a Service account.

2. Go to your My Profile page if you are not already there.

3. Under Applications, click FiveTran.

4. Respond to the second-factor authentication challenge. If you respond successfully, you are logged in to FiveTran.