Configure CSV File Location

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. Click Configure.
    click configure.

  2. On the next screen, don’t change the recommended region under Select Region unless you know for sure that you need to change the region. Then click 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 do not need to click on the link that reads Create a gateway in Azure. For additional 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 will remember like SDSServiceAccount and record the name and password you choose as you will need to use it again.
  6. Uncheck the option “User must change password at next logon.”
  7. Optional: Check the option to “Password never expires.”
  8. Click 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 click and select New > Folder.
  4. Enter Folder Name. In this example, we are creating the folder named “CSV files”.

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

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

  2. Go to the Security tab.

  3. Click Edit.
    properties, security and edit.

  4. Click Add.

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

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

  7. Click OK.
    click ok.

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

  9. Click OK.

    click 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.


Set up your SDS Flow