Skip to main content

Connector

Here you can specify connection to a data source like SAP or other programs that can not be called directly using their databases. After completing a connector, it can be used as a data source inside the data model. And an object view or container view should be created to see if the connection as successful or not.

When creating a connector you can give it the following information:

PropertyDescription
NameThe name of the connector
TranslationThe name of the connector in different languages.
UsageDepends on connector type, for example if you only want to read object or you want to write into a relational table.You can select any of:
  • Document store/read
  • Document store/write
  • Document Store/Bulk
  • Data source read
  • Data source write
  • Data source Db Connection
  • Data source read with method type
  • Relational Read
  • Relational Write
  • Relational Create Structure
  • Relational Packages
  • Relational Stored Procedure
  • Relational Functions
  • Object Read
  • Object Write
  • VariablesHere you can specify variables that can be used later on when creating the script to read connect to the outside source
    Before execute workflowWorkflow to be executed before connecting
    After Execute workflowWorkflow to be executed after connecting

    Datasources

    Here you can create a connection that can be used later on in a data model for connection, it should be of type No data source.

    Datastructure / Relational / Object / Multidimensional

    Depending on the type of the data you will have to create a corresponding table/object that can hold the data that you want to get from the connecter.

    Scripts

    Here you will create a script that can be used later on to get elements from the connection, for example if you want to read data from a document object, you will need to create at least 2 methods, the first to get only the top element from the data source, the second to get all elements. To build a connection you should use an HttpClient object.

    Workflow-Mapping

    Here you can map specific requests to the script you created above using workflow blocks, for example an execute script workflow block.

    Available requests are:

    RequestDescription
    SelectSelect multiple elements from the connector
    FirstSelect only one element from the connector
    UpdateUpdate a specific element from the connector
    ReplaceReplace a specific element from the connector
    InsertInsert a new element into the connector
    DeleteDelete a specific element from the connector
    CountGet the number of elements from the connector