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 rule or connector business rule.  A code snippet of similar implementations would be helpful.

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