Migrating DataManager 8.4 to Datamanager 10.2.1

[Gary]

We are migrating from Cognos8.4 to Cognos 10.2.1.

As per the release notes from IBM there was not much change in the ETL.

During the installation f the ETL catalog using catimp command from Linux Server, we got the error that the Catalog tables does not exist. The installation team did not create ant catalog before importing the new one.

Is there any way to create the Catalog tables from Linux/Sql statements to execute on the UAT/PRD env. Or we create from Windows interface only.

For information : We are using Oracle as DB

I tried the same on Windows install manual steps on Dev env. But this is not advisable by the Client to don On UAT/PRO installations.

Thanks
Dilsher Singh.

[MFGF]

We are migrating from Cognos8.4 to Cognos 10.2.1.

As per the release notes from IBM there was not much change in the ETL.

During the installation f the ETL catalog using catimp command from Linux Server, we got the error that the Catalog tables does not exist. The installation team did not create ant catalog before importing the new one.

Is there any way to create the Catalog tables from Linux/Sql statements to execute on the UAT/PRD env. Or we create from Windows interface only.

For information : We are using Oracle as DB

I tried the same on Windows install manual steps on Dev env. But this is not advisable by the Client to don On UAT/PRO installations.

Thanks
Dilsher Singh.

If you have a Windows machine handy with the Data Manager 10 Designer on it, you could connect to the empty database and the designer will create the catalog tables for you. Alternatively, launch the Data Manager 8 designer and open the current catalog. Go to Tools > Manage Database Schema, make sure the correct catalog database is selected, then press the Create button. You can then save the generated Create Table statements as a SQL file by pressing the Save button. Take this SQL file and run it in the db admin tool on your Linux server.

Cheers!

MF.

[Gary]

Thanks

I tried this and worked well.

[Gary]

Hello

I was able to do with windows installation.
How is it possible to do incase we donot have windows installation( incase of Prod).

is it possible to copy the DDLs for the catalog tables and ask to DBA to execute on DB to create the same? Or is there any other way.

Gary

[MFGF]

is it possible to copy the DDLs for the catalog tables and ask to DBA to execute on DB to create the same? Or is there any other way.

Yes - assuming you have a working instance of Data Manager 10 already on another server, go into the Data Manager Designer, and go to Tools > Manage Database Schema. There are buttons at the bottom for Create, Index and Grant - they will generate DDL which you can save as .SQL files and send to your DBA.

Cheers!

MF.

[Gary]

Thanks
I did the same.

But i was wondering if we can do it without manually copying the SLQ from Windows installation.