Search found 516 matches
- Mon Apr 03, 2023 10:08 am
- Forum: General
- Topic: Upgrade issue - Update Installer detected an instance of Installation Manager.
- Replies: 0
- Views: 19782
Upgrade issue - Update Installer detected an instance of Installation Manager.
While upgrading DataStage from 11.51 to 11.7.0, prereq checker is failing with following message: WARNING: The Update Installer detected an instance of Installation Manager on your system. Please uninstall Installation Manager. Resolution: Uninstall Installation Manager using the instructions given ...
- Tue Jun 28, 2022 1:42 pm
- Forum: General
- Topic: DataStage to IBM Cloud Pak for Data migration.
- Replies: 0
- Views: 8073
DataStage to IBM Cloud Pak for Data migration.
Has anyone migrated from DataStage to IBM Cloud Pak for Data? If yes, can you please share your experience and advise.
More specifically ... what was the effort needed in terms of rewriting code, testing, bugs etc? Also, what are the advantages for preexisting / well functioning code?
More specifically ... what was the effort needed in terms of rewriting code, testing, bugs etc? Also, what are the advantages for preexisting / well functioning code?
- Fri Oct 08, 2021 9:11 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Hierarchical stage Question.
- Replies: 1
- Views: 12533
Hierarchical stage Question.
We have few Hierarchical stage jobs on a DataStage (11.5) need to be enhanced soon. Upgrade of this server to a newer DataStage version is few months out. Due to adverse CBA, Harmon's Flash player does not appear to be a feasible alternative. Can you please share your thoughts on an alternative solu...
- Thu Oct 07, 2021 12:25 pm
- Forum: General
- Topic: Hierarchy stage not working with flash gone now
- Replies: 3
- Views: 13655
Re: Hierarchy stage not working with flash gone now
Hello Simc, Which solution did you pursue for Flash replacement?
- Thu May 14, 2020 11:54 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Oracle to PostgreSQL.
- Replies: 1
- Views: 11884
- Sun May 03, 2020 11:32 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Oracle to PostgreSQL.
- Replies: 1
- Views: 11884
Oracle to PostgreSQL.
We are using Datastage 11.51 to copy tables over from Oracle 12G to PostgreSQL on GCP platform. IBM's ODBC driver is being used to connect to PostgreSQL. [img]Oracle%20Connector%20---->%20ODBC%20/%20PostgreSQL[/img] Table metadata is populated in Column definition tab. Unfortunately table creation i...
- Thu Aug 15, 2019 12:31 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Postgresql JDBC
- Replies: 2
- Views: 3762
- Tue Aug 13, 2019 1:10 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Character substitution using MODIFY stage.
- Replies: 0
- Views: 3216
Character substitution using MODIFY stage.
We are using RCP to extract data from table and write to a sequential file. Double-quote is present in some of the data column, which needs to be escaped (i.e. replaced with two double-quotes). If transformer stage is used (with RCP) for replacing double-quotes, then column position in output file i...
- Fri May 10, 2019 8:24 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Need help in creating transposed file
- Replies: 8
- Views: 6662
As source is DB2 table, you can also pivot data in DB2 SELECT statement. See theseexamples.
- Mon May 06, 2019 10:37 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Need help in creating transposed file
- Replies: 8
- Views: 6662
As UCDI has mentioned ... an option is to leverage looping transformer. (I believe that Tony Curcio had published an example for similar use case in his blog. Unfortunately, I am not able to find link to that example). Alternatively, if it possible to stage incoming data in a sequential file ... you...
- Thu Apr 25, 2019 10:01 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Need to publish message to Kafka Cluster
- Replies: 3
- Views: 4404
We were also not able to connect to Kafka cluster via SSL on DataStage 11.5. IBM's response was that Kafka connector doesn't support environment variables. It only works if it is hardcoded in Datastage as in 11.7 IIS Version. In 11.7 under properties of Kafka connector there are several protocols/au...
- Tue Jan 29, 2019 4:22 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Parallel DataStage Jobs Hanging Intermittently - Oracle?
- Replies: 11
- Views: 9763
- Tue Jan 29, 2019 3:43 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Does version 11.7 support Google BigQuery and GCS?
- Replies: 1
- Views: 3832
- Fri May 18, 2018 9:55 am
- Forum: Enhancement Wish List
- Topic: DataStage connector for Azure SQL DataWarehouse
- Replies: 0
- Views: 14815
DataStage connector for Azure SQL DataWarehouse
We have opened a RFE requesting IBM Infosphere DataStage connector or ODBC/JDBC driver in DataStage for connecting with Microsoft Azure SQL Data Warehouse.
Can you please vote for it using following link.
Can you please vote for it using following link.
- Fri May 18, 2018 9:52 am
- Forum: General
- Topic: Connect to Azure Data Lake Store?
- Replies: 2
- Views: 3780