Creating different DB type connections using MTM

[Former Member]

Hi,

I have replicated the reports, universe, connection using MTM.

My source universe is pointing to SQL server with some DSN but where as my target or replicated universe has to point to Oracle DB.

While creating the connection i don't see any parameters specifying the database type, drivers etc (as shown below)

Is there anyway to achieve this?

#   <###> = (String)(required) uniquely identify the connection db setting

#   <template_CCIS.CONN_CUID> = (String)(required) CUID of the template CCIS Connection object

#   <DATASOURCE> = (String)(required) name of the data source

#   <DATABASE> = (String)(required depending on datasource) name of the database

#   <USER> = (String)(required) user id for the database

#   <PASSWORD> = (String)(required) password for the supplied database user id. Leave empty if the password is blank.

# Example:

#   ccis.dataconnection.dbcredentials1=ARiyILQC6h5Ogwf8VolZzqQ;tenantDBN;tenantDB;userABC;Password123

If i give the sql cuid, oracle dsn, oracle db, username, password then it is replicating the connection but it is still pointing to sql server drivers same as that of templated connection.

Is anybody faced this kind of scenario?

thanks in advance

[former_member4998]

Hi

my target or replicated universe has to point to Oracle DB.

You need to create  TNS entire on BO servers,

Provide the below info while creating.

Connection Type: Relational connection

DB middleware: Oracle 11, Oracle client.

Authentication mode: users specified username and pw

Unser name:

PW:

Service: Oracle server name.

[Former Member]

Thanks for reply,

I have created the TNS entries and created DSN as well in BO server.

My question is how to give these details in MTM (multitenancy management tool) properties file for creating the connection to the new tenant.