Creating a Microsoft SQL Server Connection

You must create a SQL Server connection before you can use the TIBCO Flogo® Connector for Microsoft SQL Server activities. The Microsoft SQL Server connection contains all the parameters required to connect to the Microsoft SQL Server database. The Microsoft SQL Server connection is used by all the activities in the Microsoft SQL Server category.

Note: By default, the Microsoft SQL Server database listens for connections on port 1433, although that is configurable as port is the connection property on the Microsoft SQL Server connector.

To create a Microsoft SQL Server connection, perform the following steps:

  1. Click the Connections tab and perform one of the following actions:
    • To add a connection for the first time, click the SQL Server Connector card. You can search for a connector by typing the connector name in the search field.
    • If you have existing connections and want to add a new connection, click the Add Connection link.
  2. In the SQL Server Connector dialog box, enter the connection details. For field descriptions, see Microsoft SQL Server Connection Details.
  3. Click Save Connection.
Related concepts
Related reference