Question Re: Datasource connection switch between environments in Crystal enterprise reports in Technology Q&A

Datasource connection switch between environments in Crystal enterprise reports

Former Member — Thu, 23 Mar 2017 16:14:03 GMT

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

Re: Datasource connection switch between environments in Crystal enterprise reports

Former Member — Thu, 23 Mar 2017 16:38:57 GMT

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

Re: Datasource connection switch between environments in Crystal enterprise reports

vitaly_izmaylov — Thu, 23 Mar 2017 17:25:10 GMT

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?

Re: Datasource connection switch between environments in Crystal enterprise reports

Former Member — Thu, 23 Mar 2017 18:00:54 GMT

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

Re: Datasource connection switch between environments in Crystal enterprise reports

vitaly_izmaylov — Thu, 23 Mar 2017 18:09:16 GMT

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?

Re: Datasource connection switch between environments in Crystal enterprise reports

Former Member — Thu, 23 Mar 2017 18:11:36 GMT

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

Re: Datasource connection switch between environments in Crystal enterprise reports

Former Member — Thu, 23 Mar 2017 18:13:21 GMT

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

Re: Datasource connection switch between environments in Crystal enterprise reports

vitaly_izmaylov — Thu, 23 Mar 2017 18:15:32 GMT

The question is really for the specialists in Promotion Manager.

Re: Datasource connection switch between environments in Crystal enterprise reports

Former Member — Thu, 23 Mar 2017 18:28:54 GMT

I meant SQL to change datasource

Re: Datasource connection switch between environments in Crystal enterprise reports

Former Member — Mon, 09 Oct 2017 17:26:49 GMT

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.