Cube using Different DB servers

Modified on Thu, 14 Mar 2024 at 01:52 PM

Creating Cube using Databases on Different DB Servers : 

 

We can create a DB remote link (or Linked Server) to access DB from one database server to another DB server. 

 

E.g.

 

We have two different DB Servers as shown below :

 

1) 10.0.0.121

2) 10.0.0.51

 

 

 

We can create New Linked Server under Server Objects as shown in above screen shot.

 

Click on New Linked Server below pop up window will open. We need to kid in the server name.

 

 

 

 

 

Under security section we need to configure the login for which access is to be provided. Give credentials in Remote User and Password fields. Rest keep default settings.

 

 

 

Click OK.

 

Now using this we can access any DB on 10.0.0.51 from 10.0.0.121 as :

 

select * from [10.0.0.51].[MCEXCEL].dbo.skat

 

This query can be used to to create cube. We can even join any databases available on two servers for it and create the cube. This is very performance centric point with respect to EJBI.

 

Data Source Created with 10.0.0.121

 

 

 

Creating cube using 10.0.0.51 DB Link.


 

  Using this, usage of linked cubes can be avoided to enhance the performance.


Note: This article is based on Smarten Version 5.x. This may or may not be relevant to the Smarten Version 5.x you may be using.

Linked cube DBLink Multiple DB Servers Linked Server Business Intelligence Support Business Intelligence Articles Business Intelligence Training

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons

Feedback sent

We appreciate your effort and will try to fix the article