Learn
No results for 'undefined'
    Powered by Algolia

    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

    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")

    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(...)

    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