sql-serverssisetltibcotibco-ems

How to connect TIBO EMS using SSIS


We have a requirement in our project to read the messages from TIBCO EMS using SSIS. As I know there no out of box feature to connect EMS using SSIS. Could anyone help me to solve this?


Solution

  • You have to search for TIBCO ODBC adapter and use ODBC connection manager from SSIS:

    Update

    There is no component to read data from TIBCO EMS, in order to achieve that you have to consume data from EMS using TIBCO EMS .net API and a Script Component as a source, since i didn't works before with TIBCO services i will try to provide some helpful links on how to use Script component as source and how to use .net api:

    TIBCO EMS .Net API

    Using Script Component as Source