Creating New Microsoft SQL Server Connections

Arcadia Enterprise supports Microsoft SQL Server data connections.

The following steps demonstrate how to create new Microsoft SQL Server data connections. Before making this connection, ensure that the drivers are properly configured, as described in Setting up the MS SQL Driver.

Developer Notes:

Note the following known issue that affects Microsoft SQL Server connections:

Create New Data Connection Modal Window: Microsoft SQL Server
Create a New Microsoft SQL Server Connection
  1. On the main navigation bar, click Data.

    Click DATA on main navigation bar

    The Data view appears, open on the Datasets tab.

    Main landing page of DATA
  2. In the side bar, click New Connection.

    Create New Connection

    The Create New Data Connection modal window appears.

  3. In the Create New Data Connection modal window, under Connection type, select Microsoft SQL Server.
  4. Under Connection name, specify the name of the new connection. Here, we use MicrosoftSQLConnection.
  5. Under Hostname or IP address, specify the name of your database host, or its IP address; use localhost when the data source is local.

  6. Under Port #, enter the port number. The default port # for Microsoft SQL Server connections is 3306.
  7. Under Database, specify the name of the target database. Here, we use my_database.
  8. Under Credentials, complete the following entries.

    • Under Username, enter the username for establishing the connection.

    • Under Password, enter the password for establishing the connection.

  9. At the bottom of the modal, click Test.

    testing connection
    Testing the New Connection

    If the connection is valid, the system returns a 'Connection Verified' message.

  10. Click Save.

    connection verified, connecting
    Connecting a Verified Connection

Result Cache Options

  • Click the Cache tab.

    Cache tab, specifying Result Cache Enable and Retention Time options
    Specifying Cache
  • Select the Result Cache option to enable periodic cache updates.

  • In the Retention Time field, specify the frequency of cache updates, in seconds.

    For example, the default value of 86400 indicates an update every 24 hours, and a value of 300 initiates a refresh every 5 minutes.