DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 518 matches
Author Message
 Topic: DataStage connector for Azure SQL DataWarehouse
rkashyap

Replies: 0
Views: 131

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

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

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

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

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: 4
Views: 338

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: 4
Views: 338

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& ...
 Topic: Hive Connector Vs ODBC Connector
rkashyap

Replies: 4
Views: 1329

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Mar 05, 2018 4:16 pm   Subject: Hive Connector Vs ODBC Connector
Hive connector leverages JDBC connectivity.

We are using both ODBC Connector and Hive Connector for connect with Hive and have not seen much difference between the performance of the two.
 Topic: JDBC-Connector issues
rkashyap

Replies: 6
Views: 778

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Feb 26, 2018 6:14 pm   Subject: JDBC-Connector issues
You can see the SQL statement performing Delete and subsequent Insert in DataStage Director. Confirm that ALL columns that the connector can be paired with the target table.
 Topic: Install on Remote DB2 with SSL port
rkashyap

Replies: 2
Views: 292

PostForum: General   Posted: Thu Feb 22, 2018 7:07 pm   Subject: Install on Remote DB2 with SSL port
Are you trying to create a connection from DataStage to a DB2 database with SSL?
 Topic: How Pivot Stage works in Server Edition of Datastage 11.5
rkashyap

Replies: 3
Views: 568

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Thu Feb 22, 2018 6:18 pm   Subject: Re: How Pivot Stage works in Server Edition of Datastage 11.
I'm trying to convert multiple rows into one row. I can see the Pivot stage in Processing Palette, but I don't see the properties of Pivot stage other than Input and Output.
Requirement is to perform ...
 Topic: List the sequencers which uses environmental variable
rkashyap

Replies: 2
Views: 270

PostForum: General   Posted: Thu Feb 22, 2018 5:51 pm   Subject: List the sequencers which uses environmental variable
Alternatively, if you are using Operations Console, then you can modify following query to get the desired resultSELECT
H.HostName
, J.ProjectName
, J.JobName
, P.ParamNa ...
 Topic: List the sequencers which uses environmental variable
rkashyap

Replies: 2
Views: 270

PostForum: General   Posted: Thu Feb 22, 2018 5:29 pm   Subject: List the sequencers which uses environmental variable
TryLIST DS_JOBS WITH JOBTYPE = 3 AND EVAL "TRANS('DS_JOBOBJECTS','J\':@RECORD<5>:'\ROOT',14,'X')" LIKE ...FTP_EPSILON_HOST...
 Topic: JDBC-Connector issues
rkashyap

Replies: 6
Views: 778

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Feb 22, 2018 5:08 pm   Subject: JDBC-Connector issues
What is value of "[url=https://www.ibm.com/support/knowledgecenter/en/SSZJPZ_8.7.0/com.ibm.swg.im.iis.conn.odbc.help.doc/topics/r_codbccon_cn_Drop_unmatched_fields.html]Drop unmatched fields" in the J ...
 Topic: Two Source Match Stage, long running job and fails at last
rkashyap

Replies: 4
Views: 516

PostForum: IBM QualityStage   Posted: Fri Feb 16, 2018 10:21 am   Subject: Two Source Match Stage, long running job and fails at last
Is the job using bounded length varchars in the data? If yes, then setting the [url=https://www.ibm.com/support/knowledgecenter/en/SSZJPZ_11.7.0/com.ibm.swg.im.iis.ds.parjob.adref.doc/topics/r_deeadvr ...
 

 Jump to:   



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