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. 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 is the connection property on the Microsoft SQL Server.

To create a Microsoft SQL Server connection, click the Connections tab on the TIBCO Cloud Integration- Flogo (PAYG) page.

If this is the first connection you are adding, do the following:
  1. Click the SQL Server Connector tile.
  2. Enter the values for the fields in the SQL Server Connector dialog. See SQL Server Connection Details topic for a description of the fields.
  3. Click Connect.
If you already have existing connections for any connector in TIBCO Cloud Integration- Flogo (PAYG), the connections will be displayed on the Connections page.
  1. Click Add Connection.
  2. Click the SQL Server Connector tile.
  3. Enter the values for the fields in the SQL Server Connector dialog. See SQL Server Connection Details topic for a description of the fields.
  4. Click Connect.
Related concepts
Related reference