Forum Discussion
Real time streaming data from IBM MQ Manager
- 1 year ago
Hi Sureshmannem,
Thank you for reaching out to the Microsoft Fabric community forum. We understand that you want to ingest streaming data from IBM MQ into Microsoft Fabric in real-time.
Since IBM MQ is not a built-in connector in Microsoft Fabric, please follow the steps below using Azure services for real-time ingestion:
-
Use Azure Logic Apps (Standard) with the IBM MQ Connector. Create a Logic App (Standard) and use the trigger “When a message arrives in MQ queue.” Configure your MQ connection by providing Queue Manager, Host, Port, Channel, Queue, SSL/TLS, and credentials. Then, add an action to publish messages to Azure Event Hub. Make sure the TLS/SSL certificates are properly configured in Logic App or App Service Environment if you are using custom certificates.
-
Ingest data into Microsoft Fabric. Use the Event Hub as the source for Fabric’s Real-Time Analytics. Create a KQL database or a SQL streaming table to ingest and analyze the data. You can also use Dataflows Gen2 or Data Factory Copy Activity for further processing if needed.
Also, please refer to the following links for more information:
Connect to IBM MQ - Azure Logic Apps | Microsoft Learn
Connector overview - Microsoft Fabric | Microsoft Learn
MQ - Connectors | Microsoft Learn
Azure Synapse Data Explorer data ingestion overview (Preview) - Azure Synapse Analytics | Microsoft LearnIf you find this response helpful, kindly mark it as the accepted solution and give kudos. This will help other community members with similar questions.
If you have any further queries, please feel free to ask in the Microsoft Fabric community.
Thank you.
-
Hi Sureshmannem,
Thank you for reaching out to the Microsoft Fabric community forum. We understand that you want to ingest streaming data from IBM MQ into Microsoft Fabric in real-time.
Since IBM MQ is not a built-in connector in Microsoft Fabric, please follow the steps below using Azure services for real-time ingestion:
-
Use Azure Logic Apps (Standard) with the IBM MQ Connector. Create a Logic App (Standard) and use the trigger “When a message arrives in MQ queue.” Configure your MQ connection by providing Queue Manager, Host, Port, Channel, Queue, SSL/TLS, and credentials. Then, add an action to publish messages to Azure Event Hub. Make sure the TLS/SSL certificates are properly configured in Logic App or App Service Environment if you are using custom certificates.
-
Ingest data into Microsoft Fabric. Use the Event Hub as the source for Fabric’s Real-Time Analytics. Create a KQL database or a SQL streaming table to ingest and analyze the data. You can also use Dataflows Gen2 or Data Factory Copy Activity for further processing if needed.
Also, please refer to the following links for more information:
Connect to IBM MQ - Azure Logic Apps | Microsoft Learn
Connector overview - Microsoft Fabric | Microsoft Learn
MQ - Connectors | Microsoft Learn
Azure Synapse Data Explorer data ingestion overview (Preview) - Azure Synapse Analytics | Microsoft Learn
If you find this response helpful, kindly mark it as the accepted solution and give kudos. This will help other community members with similar questions.
If you have any further queries, please feel free to ask in the Microsoft Fabric community.
Thank you.