Documentation

Documentation

  • Getting Started
  • Core Concepts
  • Using Fivetran
    • Fivetran IPs
    • Fivetran Dashboard
      • Connectors
      • Transformations
      • Destinations
      • Alerts
      • Organization Management
      • Account Settings
      • User Management
    • Features
  • Usage-Based Pricing
  • Connectors
  • Applications
  • Databases
  • Files
  • Events
  • Functions
  • Destinations
  • Partner-Built
  • Transformations
  • Logs
  • Security
  • REST API
  • Local Data Processing (HVR 6)
  • Release Notes
RSS
Release notes RSS
HVR 5 Documentation
HVR 5 Documentation
  • Support
  • Sign In
Edit on GitHub

Organization Management Betalink

Updated September 25, 2023


Overviewlink

Organizations in Fivetran serve as a central control point for all Fivetran accounts within your organization.

Companies often have several business units or subsidiaries that need to independently manage their own data pipelines, which means each business unit or subsidiary has its own Fivetran account. Also, organizations commonly have a centralized group, such as an IT or finance team that requires oversight and access to anything under their purview, with the most common points of interest being:

  • Insight into how Fivetran is being used across the entire organization
  • Managing and/or enforcing settings across the entire organization
  • Viewing usage and managing billing
  • Granting resource access and permissions to select employees across all business units or subsidiaries

Organizations in Fivetran allow accomplishing all these goals.

NOTE: We recommend using organizations when you need to use separate security settings - SAML or SCIM. We recommend using teams when you want to ensure that only the relevant users or groups of users have access to the relevant destinations, connectors or account settings.


Enabling and onboarding into organizationlink

  1. (Optional) If you don't have a Fivetran account, sign up for a Fivetran free account trial.
  2. Contact your Fivetran representative. The representative will be able to set up your account as an organization. We will create an organization and automatically promote the oldest Account Administrator that's still active to an Organization Administrator.
  3. For the first time, the Organization Administrator must log in using the username and password. After the first-time login, the Organization Administrator can select to use an alternative authentication type, such as SAML or Google OAuth.
  4. The Organization Administrator can add and manage accounts in your organization.

Accounts within an organizationlink

Creating a new account or migrating an existing accountlink

  1. Go to Organizations > Accounts.

  2. Click Add Account.

    Add Account

  3. In the pane displayed on the right, enter the account name.

    Account details

  4. Select the Account Tier for the account. Available plans are as follows:

    • Enterprise
    • Business Critical
  5. (Optional) If you want to restrict authentication type for account users, select one of the following Required Authentication Types instead of the default No restrictions option:

    • Google OAuth
    • SAML

    NOTE: If the organization requires that Google OAuth or SAML authentication be used, then the corresponding option will be selected and the menu disabled.

  6. Click Add Account.

Migrating an existing accountlink

Work with your Fivetran representative to move your existing account(s) to your organization.

Managing existing accountslink

NOTE: When you have organizations enabled, you log in to the default account in the organization. You can switch between the organization's accounts.

  1. Go to Organizations > Accounts.

    Accounts

    The table provides an overview of the list of accounts, administrators for each account, and the number of connectors/destinations within the account.

  2. In order to switch to a specific account, click Switch Account in the top left corner and select the desired account.

    Switch Account


Billing and usagelink

Navigate to Organizations > Billing & Usage to view and manage your organization's usage and billing. The page will provide you with all the relevant information regarding your ogranization's payments, subscription period, and usage accross all accounts.

The Billing tablink

Billing

On the Billing tab of the Billing and Usage page, you can do the following:

  • View monthly spend filtered by year and account
  • View your subscription period usage
  • View your balance usage
  • Click Talk to Sales to file a balance replenishment request
  • View your payment type
  • View transaction history filtered by year and ordered by date

The Usage tablink

Filter usage

On the Usage tab of the Billing and Usage page, you can do the following:

  • View spend across all accounts filtered by year and month
  • View number of accounts within your organization filtered by year and month
  • View the following usage parameter per account and order the account list by them:
    • Account - account name
    • Total spend - total spend in USD
    • % of org spend - percentage of the account's spend in the organization spend
    • Paid MAR - paid MAR per account
    • Spend rate - spend rate in USD per one million MAR
    • Plan - the account's plan:
      • For active accounts, the possible values are:
        • Enterprise - the lower-tier plan
        • Business Critical - the top-tier plan

        IMPORTANT: If a plan was switched for the account within the set month, the usage data for this month is calculated and displayed for the Enterprise plan.

      • For frozen or deleted accounts, Legacy is displayed
  • Drill down to account's usage data by clicking the relevant account in the account list. You will be re-directed to the account's Usage tab. The same month and year filter value that you set for the organization will be set for the account.

Users and permissionslink

Roles and permissionslink

Three roles are available for users at the organization level. These roles apply only to users associated with the organization and cannot be assigned at the account level.

  • Organization Administrator - Organization administrators have full access to the entire organization and all accounts within it. We recommend having two organization administrators assigned to the organizations.

  • Organization Billing - Organization billing users have access to view billing & usage for all accounts within the organization. However, they can’t view or modify entities such as destinations, connectors, or transformations.

  • Organization Reviewer - Organization reviewers have read-only access across the organization and all accounts.

Creating a new userlink

You can create new users in the following ways:

  • Enable Just-In-Time (JIT) user provisioning to automatically create a new user in Fivetran during the first-time login when using SAML authentication
  • Create a new user in your Fivetran dashboard

Take the following steps to create a new user in your Fivetran dashboard:

  1. Go to Organizations > Users.

    Users

  2. Click Add User.

    Add user

  3. Enter the following information in the popup:

    • First Name
    • Last Name
    • Email

    User details

  4. Select the desired user role from the drop-down menu:

    • Organization Administrator
    • Organization Billing
    • Organization Reviewer

    TIP: You can see the exact permissions for each organization role by hovering over the role information icon in the menu.

  5. Click Add User. The user will be invited to join your organization by email.

Managing userslink

Organization administrators can change the role of a user or delete a user within an organization.

  1. Go to Organizations > Users.

  2. To change the user's role in the organization, open the Organization Role drop-down menu in the relevant user's row, and select a new role for the user.

    Change role

  3. To delete a user from the organization, click the trash can button in the relevant row of the user list.

    Remove user

  4. Click Remove to confirm the delete action.

    Confirm deletion


Securitylink

Navigate to Organizations > Security to manage your organization's authentication and SAML configuration settings.

Settings

Authentication settingslink

  1. (Optional) Select the Required authentication type for users within the organization. The available options are as follows:
    • None - Any authentication type is allowed. This is the default value.
    • Google OAuth
    • SAML - If you Enable SAML authentication for your organization through an identity provider like Okta, Onelogin, or any other SAML 2.0 provider, you need to configure SAML for your organization.
  2. (Optional) If you want to use Just-In-Time (JIT) user provisioning, set Enable user provisioning to ON.
  3. Click Save.

SAML configurationlink

IMPORTANT: Note that the following SAML configuration flow is set up at the organization level. Each account has its own SAML and SCIM configuration.

  1. Set the Sign on URL field value to the one provided by your SAML identity provider.
  2. Specify the Issuer by copying the issuer value from your SAML identity provider.
  3. Copy and paste your SAML identity provider's public certificate to the Public certificate field. Your public certificate should not include leading and trailing labels such as -----BEGIN CERTIFICATE----- and -----END CERTIFICATE-----. Copy and paste only the value between these labels.
  4. Specify the dedicated organization entity ID as a value for Application identifier (Entity ID).

    IMPORTANT: The default Fivetran SAML application's Entity ID 'Fivetran' is highly likely already being used by accounts within your organization. For organization's dedicated application, you need to change the default value to a related and memorable name like 'Fivetran Org' on the side of your identity provider, which also must be unique within the organization.

  5. Click Save.

Questions?

We're always happy to help with any other questions you might have! Send us an email.

    Thanks for your feedback!
    Was this page helpful?