MultiSource Universe Clarification

[Former Member]

Hi,

My Question is regarding SAP BO 4.0 Information design tool, we have created MultiSource Universe and for which we have shortname e.g 'abc', while the shortname is defined, the catalog name e,g (catalog_1) is the default created and keeps changing whenever we chnage the connection

Our thinking was to keep the shortname & catalog name as one, i,e if shortname value is 'ABC', Then the catalog name has to be the same.

Question here is What's the difference/significance between the Short Name and the Catalog name? also, do we need to change the catalog name everytime we modify the connection, or do we leave it alone?

conn_first-->shortname is 'FIRST' & catalog name is 'CATALOG_1'

In a multisource-enabled data foundation, the table name as it appears in SQL expressions has the format: <@catalog(short name)."database _qualifier.database_owner".table_name.>

CHANGE CONNECTION

conn_second-->shortname is 'FIRST' & catalog name is 'CATALOG_2'

Here while configuring the connections, do we need to keep the shortname and catalog name same, ie 'FIRST' or catalog name can be different.

Regards

Shacks

[Former Member · Accepted solution]

Hi Shacks,

Just the difference between the two:

A short name used to identify the connection in the data foundation and to modify the table name in SQL expressions. If you change the short name for the connection, the SQL expressions are automatically updated with the new name.

A default catalog name is registered automatically with the query server the first time the connection is added to any multisource enabled data foundation.

Regards,

Nakul Mehta

[Former Member · Accepted solution]

Do we need to change the Catalog name each time we modify the connection, or can we/should we leave it alone?