Jump to a Section

Overview

Authorization of a Microsoft SQL Server Account

The first time you add a Microsoft SQL Server card to a FLO, you will need to create an account configuration. This will allow you to connect to your account, save your account information, and reuse that configuration next time you build a FLO with the connector. That way, you don’t have to sign in every time you want to build a FLO with this Connector. Instead, use the configuration you have already set up. You can create and save multiple configurations and share them with your teammates.

Here’s how to set up a new configuration in Microsoft SQL Server:

  1. Enter in an Account Nickname. This should be unique so if you are connecting multiple Microsoft SQL Server accounts you will be able to tell them apart (e.g. “MSSQL 1”).
  2. Enter your Microsoft SQL Server Username and Password.
  3. Enter the Host, the server address that hosts your database (e.g. “mssql.hwoh2j5h.us-east-1.rds.amazon.com”). Do not include the protocol or port.
  4. Enter your Database name, the unique name of your database on the server.
  5. Enter the Port at which your database can be accessed. The default port for Microsoft SQL Server is  ”1433”. You can find your port in the URL used to access your database after the hostname (e.g. “[host]:1433”).
  6. Click Create to finish this configuration.

    Actions

    • Build Row Object

      Build a record that you can insert into your database

    • Create Multiple Rows

      Insert many records into your database

    • Create Row

      Insert a single row into your database

    • Delete Rows

      Remove data from your database

    • Execute Query

      Execute a raw SQL query against a database

    • Query Rows

      Read records from your database

    • Read Table

      Read schema information about a table

    • Update Rows

      Update records in your database