Skip to main content
J
JoeKlapton
Newcomer
March 10, 2023

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

  • March 10, 2023
  • 1 reply
  • 0 views

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

N
NicolasArgente
Veteran
March 10, 2023

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


    Terms & ConditionsAccessibility statement