Forum Discussion

JoeKlapton's avatar
JoeKlapton
New Contributor
2 years ago

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

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 rul...
Data Integration
NicolasArgente's avatar
NicolasArgente
Valued Contributor
2 years ago

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