Importing data from external database to OneStream DataTables using smart integration connector

New Contributor

I am trying to import data directly from an external database and store it in a temporary data table in OneStream using code.  Unsure if this needs to be achieved through extender business rule or connector business rule.  A code snippet of similar implementations would be helpful.


Valued Contributor

Hi Joe!
As you are not loading anything in the cube or in stage, It sounds like an Extender BR.
Now, the code mainly depends on the file format (XML, JSON...) or even the Connection type (RestAPI, ODBC...)
But please have a look at this :
YOu wont need the getfield List As you do not use it into a workflow IMPORT. But the rest of the code is usefull.

If it helps please give a kudo! 🙂


Connect with me on:
If you want to lift yourself up, lift up someone else.