Skip to main content
S
SriRam
Newcomer
March 8, 2023

possibility to have a direct connection to fetch data from OneStream SQL database

  • March 8, 2023
  • 2 replies
  • 0 views

Hello Team,

Do you have an update on possibility to have a direct connection to fetch data from OneStream SQL database.

Thanks.

 

 

2 replies

R
RafMarques
Newcomer
March 8, 2023

I believe you your question is similar to mine:

Reporting from vDataRecordAll view

S
SriRamAuthor
Newcomer
March 8, 2023

Thanks, looks like same objective. Did you tried any option using FDX connectors?

R
RafMarques
Newcomer
March 10, 2023

Not really - just using SQL

D
db_pdx
Contributor
March 8, 2023

Hi Kish: if you are looking to extract data from OneStream for consumption by external applications via a direct connection you should consider the REST Api.  There is a DataProvider endpoint that provides methods for getting data from: generic DataSets, Cube Views, generic SQL (from application tables for examples), and the Method Commands (which provides a whole slew of addtional data access options).  We haven't used it ourselves, but know that it exists.

You can find the documentation from the XFMarketplace for your current application version.

Cheers

    S
    SriRamAuthor
    Newcomer
    March 10, 2023

    Thanks db, are you using any REST API. Can you please guide me how to use the DataProvider?

    D
    db_pdx
    Contributor
    March 10, 2023

    Hi Kish: there is an ~40 page REST Implementation Guide provided as part of the documentation from OneStream.  You can download the documentation for your environment version from the XFMarketplace.

    Lastly, if the direct connect is not a hard requirement and you are only looking for data extracts, consider out-of-the box data exports + a BR to send the data where it needs to go.

    Terms & ConditionsAccessibility statement