Datasource connection switch between environments in Crystal enterprise reports

[Former Member]

Hi,

We use Crystal Reports Enterprise 2013. I have created a report in Dev system using JDBC connection type on a HANA database. The connection is created in IDT and published to CMC and promoted to QA. I changed the database name in IDT in QA and saved it.When I promote the report to QA in CMC the report points to the database in Dev and I have to manually map the tables by opening the report in Enterprise in QA.The tables are exactly the same except for the database name (now pointing to QA). Is there a setting in CMC or Promotion management to automatically adjust the database name when the report is promoted between environments? The database name is different in each environment.

Thanks

Deep

[vitaly_izmaylov · Accepted solution]

If you have access to KBAs the look at

1846183 - Edit Data Sources on promoted report prompts for BI Platform Logon to Origin system

at the end it says:

In BI 4.1 Support Pack 01 this behaviour has been changed based on Customer feedback. In BI 4.1 Support Pack 01 the Crystal Reports for Enterprise report file will point to the hosting system (Origin or Destination) resulting in Edit Data Sources working in either Origin or Destination system.

What is the exact version number of your Crystal Reports for Enterprise?

[Former Member · Accepted solution]

Crystal Reports for Enterprise.

Version 14.1.6.1702

Build 2013 SP6.

The Database name in Source system Development is DEVDB and Destination System is QADB

[vitaly_izmaylov · Accepted solution]

According to the KBA, it should be working correctly in the version you have.

I know Promotion manager sometimes unable to handle big packages. Have you tried promoting a single report?

[Former Member · Accepted solution]

I only promoted one report. The Scheme in our HANA system has different names between Dev and QA will that be a issue?

[Former Member · Accepted solution]

Can I use SQL command to change the connection to all tables at once. A Example command that you can give.

[vitaly_izmaylov · Accepted solution]

The question is really for the specialists in Promotion Manager.

[Former Member · Accepted solution]

I meant SQL to change datasource

[Former Member]

The HANA schema name in all three environments need to be the same. For example name in Dev cant be SAPDEV and QA be SAPQA. The report hardcodes the table name and schema name for the referred table in the report. So, having a generic schema name example: SAPHANA in all three environments of HANA (Where the BW cubes and tables are stored) will solve this issue.

[Former Member]

You can do it in Report Designer, not sue about enterprise

Go to Set datasource Location

Click in table -> Properties

Double Click Overridden Qualified table name and enter same name as show against Table Name

Repeat for all tables .

Report should now be fully portable across all schemas

Ian