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.

SQL and HTTP connectors can read and write to external systems. OPC/UA connectors can only read from external systems.

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

Since Connectors communicate with external systems, you may need to understand how to configure Connectors to fit your custom IT environment.

You will need to understand the Connector Host. It is a module of the Tulip platform that manages connections to these external systems. 

When accessing databases and APIs that are openly available from your Tulip Cloud, no additional configuration should be needed. However, if something is not working as expected, or if you would like to connect to a database, API, or machine that is not openly available from the Tulip Cloud, this article on Connector Hosts is a must-read resource.

Video Summary

Here's a video summary of connectors in action:

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.

Further Reading

Did this answer your question?