Tulip is an open platform that can integrate with your existing IT infrastructure. This integration is achieved using Connectors

Connectors are a Tulip feature that allows you to send data between HTTP APIs, SQL databases, OPC/UA servers and Tulip.

Tulip supports 3 different types of connectors: 

  • HTTP - Use this connector to access data from external APIs.
  • SQL - Use this connector to access external databases that are outside Tulip.
  • OPC/UA - Use this connector to integrate machines and devices. This is most common when connecting to CNC machines and PLCs.

To access SQL and HTTP connectors, place the cursor over the “Apps” tab from anywhere in your Tulip account and select Connectors from the Dropdown.

Tulip supports the following SQL connectors:

  • Microsoft SQL Server
  • PostgreSQL
  • MySQL
  • Oracle

To access OPC/UA connectors, place the cursor over the “Shop Floor” tab from anywhere in your Tulip account and select Machines from the Dropdown.

Each Connector can have multiple functions, or queries that will run after being triggered in an app.

Here's an example of a Connector function:

Connectors fall into two categories:

1- Data Protocol Connectors 

These are SQL and HTTP connectors that integrate your Tulip Apps with your databases and APIs.

Data protocol connectors can be used by Triggers. For example, you can create a trigger in a Tulip App that says:

  • "When the operator scans a barcode" 
  • "Look up that barcode up in my SQL database"
  • "Then go to one of three different steps based on that data." 

or... 

  • "when the operator presses this button" 
  • "send a request to my HTTP API that tracks production issues on my factory floor."

Both are self-service. As long as you can query a SQL database or external software service (like an MES or ERP), then you can write the query within Tulip.

Below is an example of calling a connector function within a Trigger in the App Builder:

WHEN 

  • "device" "Barcode Scanner" outputs at "this station"

THEN

  • "Run Connector Function" connector: "SQL Demo" "Order Lookup Multiline"
  • barcode: "device Output" "data" and save result as: "Variable" "Order Details"

2. Machine Protocol Connectors 

OPC/UA connectors allow you to feed data from: 

  • OPC/UA devices
  • Software like Kepware 
  • or the Fanuc OPC/UA server 

into Tulip and use it within Trigger logic.

After setting up an OPC connector, you will use the Machines page to manage events that originate from the OPC server.

For example, you can create a trigger in a Tulip App that says: 

  • "when my OPC/UA-connected CNC machine reports an error" 
  • "Go to the error report form and..." 
  • "Send a text message to the supervisor," 

or... 

  • "When the pressure sensor connected to my Kepware software reports a pressure reading..." 
  • "Store that in a variable so I can analyze the data in Tulip Analytics."

Below is an example of an OPC/UA connector within a Trigger in the App Builder:

WHEN

  • "machine" "spindle" outputs "estop_coil"

IF

  • "Machine Output" "estop_coil" "Is True"

THEN

  • "Data Manipulation" "Store" data: "Machine Output" "estop_coil" location "estop_coil"
  • "Go To Step" "Emergency Stop"

Learn how to set up an OPC connector

Who can use Connectors?

Most connectors are self-service. Anyone who is familiar with SQL, for example, can set up a SQL connector and write the SQL queries that will be used in the Tulip app. 

Anyone in your organization can use that SQL connector in a Tulip App through Triggers without needing to know SQL after you build the SQL queries.

Running Connectors In A Test Environment

You can use the Environments tab to set up multiple servers for each connector function. This will allow you to automatically run connector functions on a test environment when the app is in development.

Technical Details of Connectors

Connectors run on a Connector Host. A "connector host" is a computer that runs Tulip's connector host software. 

Tulip runs a cloud connector host for you automatically; no setup is required on your part. With it, you can connect to any databases, APIs, and servers that are accessible from the cloud. However, connector hosts cannot talk to things that are behind a firewall that does not allow external access. 

Getting Help with Connectors

If you're interested in using Connectors, let us know via Live Chat or through a Support Ticket via the Help button in the top right of Tulip. We will help you through the process.

Did this answer your question?