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
AshleeB
3 years agoNew Contributor III
OS Integration with Datalake
We are using Datalake as a centralized repository for raw data coming from D365, the goal is to integrate Datalake with Onestream directly but we are running into a "NO_BROWSETTABLE set to OFF" error...
erik_west
3 years agoNew Contributor
I have just begun encountering this for one of my clients. Their current data lake is azure synapse. For some hyper-secure data, they recently stood up a new serverless instance. Connecting to that instance via data adapters has worked fine, but when I tried to make my normal connector, it hit this same error.
Running sql profiler on a local lab, I can see that the typical call (using BRApi.Database.ExecuteSql) wraps the sql in NO_BROWSETABLE OFF/ON set statements. Apparently this is not supported for the serverless, so it was failing.
My workaround has been to set up a parameterized data adapter to support the desired integration query. Then I'm fetching it as a dataset instead of a dataadapter (BRApi.Dashboards.Process.GetAdoDataSetForAdapter).
One other wrinkle we just encountered, the pure existence of this external connection seems to have broken our table data manager dashboard. I was able to fix part of this, but it still fails on some of the pages. Very frustrating since I have no apparent control over this property SET...
franciscoamores
3 years agoContributor II
Hello,
have you tried ExecuteSqlUsingReader instead?
I think BRApi.Dashboards.Process.GetAdoDataSetForAdapter uses DbSql.GetDataTableUsingReader behind the scenes which is what ExecuteSqlUsingReader also does.
Related Content
- 9 months ago
- 2 years ago
- 1 year ago