Configure CSV File Location

  • Article

Step 1: Download the on-premises Data Gateway

  1. Download, save, and run the gateway installer on a local computer.

  2. Accept the default installation path, or specify the location on your computer where you want to install the gateway.

  3. Review and accept the terms of use and privacy statement, and then choose Install. install on-premise storage location.

  4. After the gateway successfully installs, provide your global administrator account, and choose Sign in. provide global admin account to sign in.

  5. Choose Register a new gateway on this computer > Next, which registers your gateway installation with the gateway cloud service.

register a new gateway on this computer.

  1. Provide this information for your gateway installation:
    • The name you want for your installation
    • The recovery key you want to create, which must have at least eight characters

Save and keep your recovery key in a safe place. You need this key when you change the gateway's location, or when you migrate, recover, or take over an existing gateway.

  1. Select Configure.
    Select configure.

  2. On the next screen, don’t change the recommended region under Select Region unless you know with certainty that you need to change the region. Then select Done.
    select region.

  3. After the confirmation page appears, choose Close. The installer confirms that your gateway is now online and ready for use.

    confirm and close.

You don't need to select on the link that reads Create a gateway in Azure. For more context, this article explains how the data gateway works.

Step 2: Create a new local service account.

  1. Go to Computer Management.
  2. Double-click on Local Users and Groups.
  3. Double-click on Users.
  4. Right-click in the center pane to Add New User.
  5. Enter a User Name you'll remember like SDSServiceAccount and record the name and password you choose as you'll need to use it again.
  6. Uncheck the option “User must change password at next sign in.”
  7. Optional: Check the option to “Password never expires.”
  8. Select Create.
    Check the option to Password never expires.

Step 3: Create a folder for your CSV files.

This is the folder location where you’ll export your CSV files to.

  1. Open File Explorer.
  2. Navigate to your C:\drive.
  3. Right select and select New > Folder.
  4. Enter Folder Name. In this example, we're creating the folder named “CSV files”.

Step 4: Give your local service account full permissions on the CSV folder.

  1. Right select on the folder you created in Step 3, and go to Properties.

  2. Go to the Security tab.

  3. Select Edit.
    properties, security and edit.

  4. Select Add.

  5. Set the Location option to your local machine. This will be the first option in the list when you select Locations.

  6. Type in the SDSServiceAccount name (that you created in Step 2, number 5) in the objects names field (third field) and select Check Names.

  7. Select OK.
    Select ok.

  8. Ensure full control has been granted to the service account. Select Apply.

  9. Select OK.

    Select apply and ok.

Step 5: Copy your CSV files into the folder.

  • Make sure that you only have CSV files in this folder.

copy your files into this folder.

NEXT STEPS:

Set up your SDS Flow