Page 1 of 1
How to get JSON file from blob storage using DataStage 11.5
Posted: Thu Apr 26, 2018 2:24 am
by Chon
I need to get JSON file from blob storage then load the data from json file to our Database. I'm using Hierarchical Stage to load the json file in our table but I dont know how to get the json file from blob storage.
Posted: Thu Apr 26, 2018 4:00 am
by eostic
Hi.
"blob storage" can mean a lot of things. Where exactly is it stored and in what medium [brand or type of database?, blob or clob datatype? Amazon S3?, something else?].
Ernie
Posted: Thu Apr 26, 2018 4:49 am
by Chon
Sorry . Forgot to include it. It is Microsoft Azure . It is possible to get the file using DataStage? Right now we are using API to get the file from blob storage then store the file in our DataStage server
Posted: Thu Apr 26, 2018 1:39 pm
by rkashyap
"Read a BLOB (GET BLOB)" section of Developerworks article
IBM Datastage Hierarchical Stage made easy to do operations on Azure-Cloud platform has information on reading Azure blob using XML connector. It may help you.
Do share your solution and experience in accessing Azure blobs from DataStage in this forum.
Posted: Fri Apr 27, 2018 1:52 am
by Chon
Thank You :D .. I'll check this