We have an system internally, DataStage job (nearly 50 Datastage jobs) should read the csv file from Azure using Datastage connector stage and load the data into SQL Server.CSV file is attached for reference. These files are coming from internal and external users working with us. They share a Sharepoint on AZURE site hosted externally at MS.
|Who would benefit from this IDEA?||Customers using Sharepoint on Azure who want to integrate with on prem databases|
How should it work?
Create a connector, log into sharepoint
Select existing files, CSV
move into SQL Server or other RDB locall
|Priority Justification||Can not use curl commands to get files from AZURE. Must download manually currently.|
|Customer Name||Ford Motor Company|
NOTICE TO EU RESIDENTS: per EU Data Protection Policy, if you wish to remove your personal information from the IBM ideas portal, please login to the ideas portal using your previously registered information then change your email to "email@example.com" and first name to "anonymous" and last name to "anonymous". This will ensure that IBM will not send any emails to you about all idea submissions