Showing results for 
Search instead for 
Did you mean: 

How to change data source of Universe

Former Member
0 Kudos


I have two databases called A_Database and B_Database

Same tables and data are in both the databases.

I created universe U_universe using A_Database. It is working fine

Now I would like to change from A_Database to B_Database in U_universe without affecting any thing in U_universe because tables and data are same.

Please let me know following doubts.

1.How to do above things?

2.if A_Database and B_Database are in different server, how to overwrite data source in the universe

3.if A_Database and B_Database are in the same server, how to overwrite data source in the universe

Thanks and Regards,


Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

You have to create first ODBC connetion for the Second Database.

Select Tools > Connections.Create new Connection there.

You can use the connection wizard to set advanced and custom parameters

for a connection.

Now in File > Paramerter. Change the connetion whcih you have ceated.

Former Member
0 Kudos

Can you please explain in detail for File> paramater? I am stuck here.

Active Contributor
0 Kudos

In Designer, import your universe, click on File>Paramers or click on parameters icon on the tool bar and change connection used by the universe from one pointing to Universe A to one pointed to universe B.

Also, visit this site :

Look for Universe Designer guide.

Answers (0)