Forum Discussion

mtejjini's avatar
mtejjini
New Contributor III
7 months ago

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...
Data Integration
Import
  • Henning's avatar
    Henning
    7 months ago

    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

     

Henning's avatar
Henning
Valued Contributor II

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

 

mtejjini's avatar
mtejjini
New Contributor III
7 months ago

thank you Henning, this is what i was missing the external connection!