The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.

Forum Discussion

danszczepanski's avatar
danszczepanski
New Contributor III
1 year ago
Solved

Reference External DB and Application DB in one SQL Query

Hello, I am writing a SQL Query that references tables in different databases, one that exists in the External database (BI Blend) and one that exists in the Application database. I am having troubl...
Analytic Blend
  • sameburn's avatar
    sameburn
    1 year ago

    Hi danszczepanski

    As Teresa and Daniel have pointed out. You can achieve this with a Dashboard DataSet BR.

    You would need to execute both sql commands separately e.g datatable1 is from application database and datatable2 is from framework database

    You can then use the DataTable Merge method (assuming both datatables have the same columns as per your union statement) to merge the two datatables.

    Then return the merged DataTable to your Data Adapter. 

    https://learn.microsoft.com/en-us/dotnet/api/system.data.datatable.merge?view=net-9.0&redirectedfrom=MSDN#overloads

    Hope this helps

T_Kress's avatar
T_Kress
Icon for OneStream Employee rankOneStream Employee
1 year ago

My understanding is that it is an Azure limitation that you cannot SQL across two different databases.  If your customer or you are on the Azure Cloud, then no this will not be possible in a data adaptor.  There are work arounds via BRs that open two database connections and then run each SQL separately and joins via BR, but not data adaptor.