Migrating BO reports From Netezza to Teradata

[Former Member]

Hi

In our organization we have BO running on Netezza database for few years now , now we are upgrading to Teradata . In this process we are planning to modify tables and columns due to adopt to new changes and merging with other line of business .

we have few thousands reports are already running on Netezza with existing database structure.  Is their a way to update the reports using backend  process to change the columns in reports rather than re designing the reports.

Any help is appreciated .

Prakash babu

[Henry_Banks]

Hi,

unfortunately, SAP doesn't provide a batch repointing utility .

this would have to be done in WebIntelligence on a per document basis, using the dataprovider "Change Source" workflow.  (at which stage you reconfirm the object mappings between old and new.)

for sure, this can be done programatically using SDK but i have no experience of it myself (see link here)

I believe there are also partner-provided solutions available for this kind of task which are externally available.

regards,

Henry

[Former Member]

You need to elaborate on the exact requirement and scenario.

When you say "modify tables and columns due to adopt to new changes and merging with other line of business ."; are you adding or removing columns from the table?

If yes, the changes should first reflect in the universe. Once done, they will automatically reflect to the reports.

When you say "Is their a way to update the reports using backend  process to change the columns in reports rather than re designing the reports." , what are the changes that you are expecting?

Follow this process:

1. Create exact replica of Netezza data model in Teradata.

2. Create new connection against Teradata and test it.

3. Set new connection for your universe to point to Teradata.

4. Do an integrity check and fix the errors.

5. Once done, save and export the universe.

6. Open associated Webi reports, refresh and check.

NOTE: Never "Save As" or "Copy" your universe to another name. This will change the CUID and will break the link with associated reports.

Regards,

Yuvraj

[Former Member]

If your reports are based on Universe and you can find a way to map the old structure to new structure, you can make the changes in the universe and all the reports(based on that Univ) will pickup the new DB structure.