Integrate with External Systems

Where can the data reside?

MINTDATA™ connects to virtually any data source, no matter where it lives, for both reading and writing data.

In many cases, MINTDATA™ also supports streaming this data to the desktop web and mobile application in real-time.

Have an API?

When an API already exists, MINTDATA™ can use/call the following types:

API Type MINTDATA™ Can Use/Call From
REST API Browser and cloud
WebService API (WSDL/SOAP) Cloud

How are APIs called?

API Type Use/Call FromVia
REST API Browser Spreadsheet functions:
REST API Cloud Spreadsheet functions:
WebService API (WSDL/SOAP) Cloud Spreadsheet functions:
  1. Create a flow
  2. Use flow functions

See details

When there’s no API

If an API does not exist, MINTDATA™ can still directly talk to a large number of data sources (and sinks) via Cloud flows.

This table shows the kinds of data sources MINTDATA™ talks to out of the box:

MINTDATA™ directly calls / interacts with From
SQL databases MINTDATA™ Cloud flows
Queues
  • Kafka ( details )
  • JMS (coming soon)
  • RabbitMQ (coming soon)
  • MSMQ (coming soon)
MINTDATA™ Cloud flows
Data Warehouse MINTDATA™ Cloud flows
NoSQL
  • ElasticSearch
  • MongoDB (coming soon)
MINTDATA™ Cloud flows

Cloud flows

Two kinds of spreadsheet functions

On MINTDATA™, there are two kinds of functions:

Spreadsheet Function Kind MINTDATA™ Runs On Example
Built-in Browser SUM(), AVERAGE(), etc.
Custom Cloud MY_READ_DATABASE_FUNC(“select * from employees”)

To create a custom function

Creating a custom function takes three steps:

  1. Open the flow editor
  2. Give the flow a name
  3. Define the flow by adding blocks and connecting them.

For more details, see Create a flow.

You now have a custom function that can be used in the spreadsheet. The name of the function is the name of your cloud flow.

To use a custom function

Once you follow the steps above to create a custom function, you can use it in any spreadsheet cell, just like any built-in function. The name of the function is the same as the name of your cloud flow.

How does a custom function work?

When you write something like this in a spreadsheet cell:

=MY_READ_DATABASE_FUNC("select * from customers")
Copy to clipboard

Here’s what happens under the hood:

  1. The spreadsheet engine in the browser encounters the cell formula
  2. It realizes this is a custom function and needs to run in the cloud
  3. Your cloud flow executes in the cloud
  4. Your cloud flow terminates in the cloud
  5. The results are sent back to the browser
  6. The cell gets the resulting value from your =MY_READ_DATABASE_FUNC() formula

How does real-time data work?

If your custom function / cloud flow talks to a real-time data source that is, something which constantly emits new values like a temperature sensor or the constantly changing values of a stock then you can also continuously stream data from the cloud flow to your spreadsheet cell.

Simply add an asterisk “*” in front of your custom function:

=*MY_REALTIME_SENSOR_READER(...)
Copy to clipboard

Here’s what happens under the hood:

  1. The spreadsheet engine in the browser encounters the cell formula
  2. It realizes this is a custom function and needs to run in the cloud
  3. Your cloud flow executes in the cloud and does not terminate
  4. All results are continuously sent back to the browser (streamed in real-time)
  5. The cell gets the resulting value from your =MY_REALTIME_SENSOR_READER() formula on a continuous basis.
Contents