DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 532 matches
Author Message
 Topic: Datastage on Azure
rkashyap

Replies: 6
Views: 325

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Sun Sep 20, 2020 6:09 am   Subject: Datastage on Azure
We are connecting to both on-premise and Azure based databases. ODBC connectivity is utilized with the Azure based databases.
Resolved
 Topic: Snowflake connector: Disabled File format options.
rkashyap

Replies: 3
Views: 102

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Sun Sep 20, 2020 6:05 am   Subject: Snowflake connector: Disabled File format options.
Issue was resolved by applying patch [url=https://www.ibm.com/support/pages/apar/JR62384]JR62384.
Resolved
 Topic: Snowflake connector: Disabled File format options.
rkashyap

Replies: 3
Views: 102

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri Sep 11, 2020 3:38 pm   Subject: Snowflake connector: Disabled File format options.
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Additional info: RHEL 75; DataStage 11.71 SP2
Our installation has multiple DataStage servers. We are trying to write to Snowflake using Snowflake connector with Write Mode "Load from file".

Unfortunately, following [url=https://www.ibm.com/su ...
 Topic: Datastage on Azure
rkashyap

Replies: 6
Views: 325

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri Sep 11, 2020 3:14 pm   Subject: Datastage on Azure
We have installed DataStage on a Redhat VM in Azure. This is basically an IAAS solution and can be used with any version of DataStage.

> Currently we are using DS11.5 ,Do we need to upgrade to 1 ...
 Topic: Oracle to PostgreSQL.
rkashyap

Replies: 1
Views: 1214

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu May 14, 2020 11:54 am   Subject: Oracle to PostgreSQL.
Issue has been identified as a product bug and sent to engineering.
 Topic: Oracle to PostgreSQL.
rkashyap

Replies: 1
Views: 1214

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Sun May 03, 2020 11:32 am   Subject: Oracle to PostgreSQL.
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Additional info: RHEL 7.
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.

ODBC_Connector_1: Error while generating th ...
Resolved
 Topic: Postgresql JDBC
rkashyap

Replies: 2
Views: 779

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Aug 15, 2019 12:31 pm   Subject: Postgresql JDBC
Is your PostgreSQL based on GCP?
 Topic: Character substitution using MODIFY stage.
rkashyap

Replies: 0
Views: 654

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Aug 13, 2019 1:10 pm   Subject: Character substitution using MODIFY stage.
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Additional info: RHEL 7.
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 ...
 Topic: Need help in creating transposed file
rkashyap

Replies: 11
Views: 1851

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri May 10, 2019 8:24 am   Subject: Need help in creating transposed file
As source is DB2 table, you can also pivot data in DB2 SELECT statement. See [url=https://stackoverflow.com/questions/13579143/how-can-i-pivot-a-table-in-db2]theseexamples.
 Topic: Need help in creating transposed file
rkashyap

Replies: 11
Views: 1851

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon May 06, 2019 10:37 pm   Subject: Need help in creating transposed file
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 ...
 Topic: Need to publish message to Kafka Cluster
rkashyap

Replies: 3
Views: 1192

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Apr 25, 2019 10:01 pm   Subject: Need to publish message to Kafka Cluster
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 Data ...
 Topic: DataStage on Cloud
rkashyap

Replies: 3
Views: 1161

PostForum: General   Posted: Tue Feb 26, 2019 9:05 am   Subject: DataStage on Cloud
We have installed DataStage in Microsoft Azure using IBM’s “Bring Your Own License” offering (IaaS). This allows us to support ETL and data integration in Cloud and also across on-premise and multi-Cl ...
 Topic: Parallel DataStage Jobs Hanging Intermittently - Oracle?
rkashyap

Replies: 11
Views: 3244

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Jan 29, 2019 4:22 am   Subject: Parallel DataStage Jobs Hanging Intermittently - Oracle?
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 ...
 Topic: Does version 11.7 support Google BigQuery and GCS?
rkashyap

Replies: 1
Views: 1162

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Jan 29, 2019 3:43 am   Subject: Does version 11.7 support Google BigQuery and GCS?
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".
 Topic: DataStage connector for Azure SQL DataWarehouse
rkashyap

Replies: 0
Views: 3660

PostForum: Enhancement Wish List   Posted: Fri May 18, 2018 9:55 am   Subject: 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 ...
 

 Jump to:   



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours