I am trying to publish a package between the development, UAT, and production servers. The data sources are identically named across the environments but the schema and catalog names are different (e.g., data source apple on all three servers with catalog and schema different because they point to three different databases). I have been creating separate versions with environment specific schema and catalog names and publishing but I would prefer to use the export/import function. I have tried to leave the schema and catalog entries blank but the package does not work. Our packages use a select statement that includes the data source name "select from datasource.table" so the package works with all environments. All data sources are Netezza and populated from an Oracle transactional database. Has anyone had and resolved this issue and if so, would you be so kind as to provide particulars on how you made this work?
Thanks
Does this post help? I have also re-attached the document I posted originally on that thread.
http://www.cognoise.com/index.php/topic,24269.msg76113.html#msg76113
This does help; thank you. Since I posted the thread, I was able to find parameters to add to the JDBC connection when creating the data source. So far, I have been able to create a new data source with those parameters, create a new model using that new data source that does not include the catalog and schema, and publish the package. I am able to open the new package in workspace advanced but am getting an error when I try to add data to the report. I am troubleshooting the issue and will update this thread with progress.