DataStage - Data Integration

 View Only
Expand all | Collapse all

How to connect Microsoft SQL server(IaaS) using API from IBM Datastage 11.7.1.2

  • 1.  How to connect Microsoft SQL server(IaaS) using API from IBM Datastage 11.7.1.2

    Posted Tue November 09, 2021 07:15 AM

    Hi all

    We are trying to connect Microsoft SQL server installed in Azure VM(IaaS) from Datastage using API.

    Currently, we are using JDBC connector to connect to microsoft sql server(IaaS)using service account and its password. But, In new server, we have to reset the password every three months in Azure. Also, same service account is being used by other applications.

    We have to create the change request to reflect the new password in the datastage PROD environment. Also, we are getting separated service account to use in Datastage.

    To avoid the password reset or lock issue, we are planning use API to get the password for connecting to the DB.

    API DB connection is working in Alteryx. Can you please let us know is it possible to connect and ways to do so in Datastage 11.7.1.2. Also, please let me know any other feasible solution for this problem, if the API connection is not possible.



    ------------------------------
    Mohan Kumar
    ------------------------------


  • 2.  RE: How to connect Microsoft SQL server(IaaS) using API from IBM Datastage 11.7.1.2

    Posted Wed December 15, 2021 06:19 PM
    Hi

    If it is based on REST API than you can leverage on Hierarchical Data Stage to connect it - https://www.ibm.com/docs/en/iis/11.7?topic=data-rest-web-services

    You should be able to leverage Java Integration Stage if you have Java Codes that can achieve the same - https://www.ibm.com/docs/en/iis/11.7?topic=connections-java-code

    ------------------------------
    HOW MING YONG
    ------------------------------