Forum Discussion

FairShawn's avatar
FairShawn
New Contributor
2 months ago

SAP SIC Data Source

Once my SIC Gateway is online, how can I apply the data sources to specific workflow profiles?

The "data source name" shown on the Custom System Configuration is not one of the available options to select for the workflow profiles.

  • Shawn,

    The "Data Source Name" you see on the Workflow Profiles page is meant for you to choose a Data Source configured in the Data Source tab in the Application pane.

     

    In the Data Source configuration, I would recommend setting up a Connector data source paired with a Connector Business Rule which queries the external source you are using with SIC. If you would like example code on querying an external database using a connector, please let me know.

     

     

     

  • The SIC provides one or more "Connections" to OneStream.  You will still need to build a Connector Data Source that uses a Connector Business Rule that in turn uses that connection to query SAP.  The Data Source is then what gets attached to an Import Workflow.  So, having the SIC up and running is great, but you still have a fair bit of heavy lifting before you can see anything from a Workflow.

  • JakeSteinberg's avatar
    JakeSteinberg
    New Contributor III

    Shawn,

    The "Data Source Name" you see on the Workflow Profiles page is meant for you to choose a Data Source configured in the Data Source tab in the Application pane.

     

    In the Data Source configuration, I would recommend setting up a Connector data source paired with a Connector Business Rule which queries the external source you are using with SIC. If you would like example code on querying an external database using a connector, please let me know.