The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi Team,
We have a requirement to ingest streaming data from IBM MQ into Microsoft Fabric.
Currently, IBM MQ does not appear as a native connector in the available sources. I’ve been exploring the custom endpoint option, but it’s not functioning as expected.
I would appreciate your support in this matter. If you have any documentation, configuration steps, or reference links that detail how to stream data from an IBM MQ Queue Manager into Fabric, please share them.
Thank you!
Solved! Go to Solution.
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 ...
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.
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 ...
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.