DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 526 matches
Author Message
Resolved
 Topic: Postgresql JDBC
rkashyap

Replies: 2
Views: 252

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: 201

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: 1091

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: 1091

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: 700

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: 689

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: 2025

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: 874

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: 2777

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 ...
Resolved
 Topic: Connect to Azure Data Lake Store?
rkashyap

Replies: 2
Views: 1076

PostForum: General   Posted: Fri May 18, 2018 9:52 am   Subject: Connect to Azure Data Lake Store?
It is not possible to connect to Azure Datalake store from DataStage.
Resolved
 Topic: Connect to Azure Data Lake Store?
rkashyap

Replies: 2
Views: 1076

PostForum: General   Posted: Wed May 02, 2018 12:07 pm   Subject: Connect to Azure Data Lake Store?
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Additional info: IIS 11.5 fp1 on RHEL 7; XMETA DB2; LDAP authentication
We are connecting to Azure SQL database from DataStage 11.50.1. Has anyone connected with Azure Data Lake Store from DataStage? If yes, please share your experience.
 Topic: How to get JSON file from blob storage using DataStage 11.5
rkashyap

Replies: 4
Views: 1402

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Apr 26, 2018 1:39 pm   Subject: How to get JSON file from blob storage using DataStage 11.5
"Read a BLOB (GET BLOB)" section of Developerworks article [url=https://developer.ibm.com/recipes/tutorials/ibm-datastage-hierarchical-stage-made-easy-to-do-operations-on-azurecloud-platform/]IBM Data ...
 Topic: DataStage 11.5 vs DataStage 11.7?
rkashyap

Replies: 3
Views: 2754

PostForum: General   Posted: Mon Apr 23, 2018 3:40 pm   Subject: DataStage 11.5 vs DataStage 11.7?
Following blog posts are also quite informative ...
Resolved
 Topic: All users (including Admin) cannot open client session.
rkashyap

Replies: 8
Views: 2025

PostForum: General   Posted: Mon Mar 26, 2018 12:34 pm   Subject: All users (including Admin) cannot open client session.
Thank you. Apparently, lots of zombie DataStage connections were being created from a rogue DataStage session on a desktop and maximum no of sessions was exhausted, thus no new session could be opened ...
Resolved
 Topic: All users (including Admin) cannot open client session.
rkashyap

Replies: 8
Views: 2025

PostForum: General   Posted: Sat Mar 24, 2018 8:09 pm   Subject: All users (including Admin) cannot open client session.
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Additional info: IIS 11.5 FP1 on RHEL 7; XMETA DB2; LDAP authentication.
Attempts to open Client session for all users including Admin are failing with message:

<Status xmlns="http://iis.ibm.com">
<httpStatus>503</httpStatus>
<msgId& ...
 

 Jump to:   



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