Solved
Data BI Blend to Cube Connector
Hi, I am trying to load data from BiBlend to cube using a import validate load steps on my workflow and using also a connector, but i truggle a bit onthe connector Businessrule, i would like to kn...
Forum Discussion
Hi, if you already have a connector to the cube, I assume you are mostly there. If you share your current BR, maybe folks here are able to help you over the finishing line more easily.
My first assumption is that you are not using the function to create an external database connection info:
Using dbConnApp As DBConnInfo = BRApi.Database.CreateExternalDbConnInfo(si, extConnName)
Once you have the SQL code to pull data from your BI Blend database, you should be able to execute it with a private sub such as this (adapt to your requirements as needed):
Private Sub ExecuteSqlOnExternalDB(ByVal si As SessionInfo, ByVal script As List(Of String))
If Not script.Count = 0
'Use the name of the database, used in OneStream Server Configuration Utility >> App Server Config File >> Database Server Connections
Dim extConnName As String = "BIBLend Local Database"
Using dbConnApp As DBConnInfo = BRApi.Database.CreateExternalDbConnInfo(si, extConnName)
'trigger only one sql cmd
Dim sqlCmd As String = String.join(vbnewline,script)
BRAPi.Database.ExecuteActionQuery(dbConnApp, sqlCmd, False, True)
End Using
End If
End Sub
thank you Henning, this is what i was missing the external connection!
