App Connect

 View Only
Expand all | Collapse all

How to pull data using AWS Athena or AWS S3 from IBM Integration bus on premises

  • 1.  How to pull data using AWS Athena or AWS S3 from IBM Integration bus on premises

    Posted Tue April 19, 2022 09:45 AM
    Hello,
    Is there a possibility to connect to AWS Athena or AWS S3 to pull data from Cloud Data hub using IBM Integration Bus v10 on premise. Also, are there options to do so by using ACE if not IIB.
    Thankyou.

    ------------------------------
    Sakshi Das
    ------------------------------


  • 2.  RE: How to pull data using AWS Athena or AWS S3 from IBM Integration bus on premises

    Posted Thu April 28, 2022 10:19 AM
    Hello,
    There are no built-in connectors at this time in ACE or IIB for this.  However, you can implement this with the existing nodes and some coding.  Athena uses JDBC, so you can use a Java compute node and the JDBC driver like you would with other databases.  S3 has a REST API, so you can use RESTRequest or HTTPRequest nodes to interact with it.

    ------------------------------
    MATTHEW SEGALL
    ------------------------------