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?
Asked
Active
Viewed 494 times
2
-
It is recommended to read the [tour page](https://www.stackoverflow.com/tour) to learn more about accepting, up-voting another rules since you asked two questions and it looks like you ignored answers provided. If they solved the issue why not accepting them else write a feedback (comment) to get more help – Yahfoufi Apr 08 '19 at 09:18
1 Answers
1
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
- SSIS to Tibco EMS messaging
- Connecting to Tibco EMS from a C# Client
- Not able to retrieve messages from topic using EMS.NET API
- All I have is a Tibco.EMS.dll, what else do I need?
- How to monitor outgoing messages from TIBCO EMS .Net client?
Using Script Component as Source
Hadi
- 36,233
- 13
- 65
- 124
-
Thank you for the response, however, I am not looking database adapter. I need to subscribe to the TIBO EMS and read the messages using SSIS. – Prasad Kada Apr 03 '19 at 14:02