Forum Discussion

dbeavon's avatar
dbeavon
Contributor
3 years ago

Retrieving data from analytic blend

There is a new column-store storage engine for reporting out of Onestream called "Analytic Blend". I have been examining the related documentation, and hoping to find an API that would allow this eng...
Dashboards
  • ckattookaran's avatar
    ckattookaran
    3 years ago

    It stores the data in a SQL database. You can then make the 3rd party apps to go against that. However, you lose the little security that OS allows you to have on the BI Blend tables (workflows and entities) if you go that route.

    Now on a cloud instance, I don't think that gets exposed. You are now at the mercy of REST APIs and PowerShell. However, I found out that regular OS users cannot use Powershell. I assume that is the case with REST API as well.

dbeavon's avatar
dbeavon
Contributor

ckattookaran Thanks.  We are running Power BI on premise.

It sounds like the SQL database is structured in a more "user-friendly" way , (and that querying these tables is fully supported).

I had heard that the core/internal SQL tables for the OS cubes aren't really intended to be used by client applications, so I didn't even start down that path.

Quick follow up question.... I think OneStream has started working on a mechanism to report from Microsoft Power BI (ie. via a "custom connector").  Do you happen to know which of their own technologies onestream will be using for that?  Will it use their own REST API?  Will it require the preparation of Analytic Blend?  Whichever approach they use will need to be fast and robust; and it may work well for similar integrations with other types of client-applications.

ckattookaran's avatar
ckattookaran
VIP
3 years ago

I've no idea. I've heard about the connector. Not sure when it is coming (or whether it is coming).