DSXchange

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 ...

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?

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...

Hello Simc, Which solution did you pursue for Flash replacement?

Issue has been identified as a product bug and sent to engineering.

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...

Is your PostgreSQL based on GCP?

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...

As source is DB2 table, you can also pivot data in DB2 SELECT statement. See theseexamples.

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...

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...

We had faced similar situation and our support provider suspected it to be a symptom of oracle bug 10178982, which was related to partition maintenance.
Similar to Franklin's suggestion, workaround was to run Oracle connector in sequential mode.

I do not believe that DataStage can connect to Google Cloud datastores.

know it supports Amazon s3 objects ( indirect way to connect google cloud bucket )

Can you elaborate on the "indirect way".

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.

It is not possible to connect to Azure Datalake store from DataStage.