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

JoeKlapton
New Contributor

I am trying to import data directly from an external database and store it in a temporary data table in OneStream using Vb.net 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.

1 REPLY 1

NicolasArgente
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 : https://community.onestreamsoftware.com/t5/Rules/REST-API-USE/m-p/3761#M158
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! 🙂

Cheers


Connect with me on:
LinkedIn: https://www.linkedin.com/in/nicolas-argente/
Website: https://aiqos.io
If you want to lift yourself up, lift up someone else.