I noticed in the 2025.10 release notes that there are new ODBC and Power BI connectors. Is there any additional documentation about how to access these and set them up?
Thanks.
I too am very interested.
Are you on Prem? If you are cloud hosted, are you using the Data Lake? Thx, Joe
We are on the cloud, using the Data Lake.
We are considering using a tool from a company in the Netherlands that uses the REST API's to replicate the Datalake data to SQL Server in Near Real Time (15 seconds roughly). Still in discussions. They have it working for LN, not Syteline. The other option is Progress SQL. They have a tool called
Progress DataDirect Autonomous REST Connector
I literally just got off a call with them. It's basically a bridge that uses the Rest API's to create a front end that you can then connect your tools to thru the Standard Microsoft ODBC Driver set. For example, SSMS or Power BI. You do need to setup the mapping for it to the Infor Rest API's which they help you with. You could Alway's replicate your data to an actual SQL Server using it if you wanted to or just access the Datalake like SQL directly with your software. Also for Power BI you would load their Restful API Tool on the Power BI Bridge on a hosted server to allow the Power BI gateway to connect to the DataLake. Allows Direct Query from Power BI Also. I wll share what I reveive from them here as I receive more information. Joe
Progress DataDirect Autonomous REST Connector allows access to REST APIs using standard ODBC SQL requests. Basically, we make these REST APIs appear as if your application was connecting to an SQL Server or a PostgreSQL database. There is no need to replicate the data from REST source into a relational database.
https://www.progress.com/connectors/autonomous-rest-connector
Here is a 3 minute ARC video:
https://www.youtube.com/watch?v=BlESRjvTQgw
Here is a 15 minute video showing using the ARC Composer to configure SQL access to a REST API:
https://www.youtube.com/embed/QNiQntUYIFM
Here is a tutorial on using ARC with Power BI. The details differ from your use case because it’s accessing a different API, but the basic steps are the same.
Hi Daniel,
Thanks for your interest in the new Infor Data Fabric connectors!
We’re excited to share that both the Power BI Connector and ODBC Driver will be available under a Limited Availability release in 2025.10. These products are not yet generally available, but Infor customers can try them out through our Early Adoption Customer Collaboration Program.
To learn more about the early adopters initiative and availability for this program, please contact your Infor representative to ask about the Early Adoption program. Please note the Early Adoption program has limited capacity due to the direct engagement it involves with our development team. opportunities to participate. Update: Connector for PowerBI early adoption program capacity is currently at max. While enrollment for this release round is currently full, we’d love to hear about your use cases and we’ll keep you updated on future
Also, it’s important to set the right expectations when querying with Compass SQL the Infor Data Lake. Even if someone manages to build a custom ODBC driver that interacts with our REST APIs (which are asynchronous), or bridge to our JDBC Driver, the Data Lake should not be treated as a traditional database. You’re querying a big data store, not an RDBMS, so latency and query behavior will differ significantly.
We strongly discourage using the Data Lake to achieve real-time or near-real-time outcomes. For example, querying the Data Lake every 15 seconds, as someone suggested, goes against our best practices and may have significant implications on your Compass licensing. Please reach out to your Infor representative to get in touch with one of our technical consultants who can help assess your use cases and guide you toward the right tools and architecture.
That said, we’re also releasing under Limited Availability a Data Warehouse and Source Data Access capabilities. These are designed to align better with real-time use cases and direct usage through the Power BI Connector, enabling live connections rather than relying on data import workflows.
For the upcoming features, we have more information in the Data Fabric roadmap in Infor Concierge, but feel free to ask us any questions. We’re happy to clarify and provide more information!
Thanks for the information. Is there any additional information on the Data Warehouse and Source Data Access capabilities. Having live or fairly live connections would be of benefit to a few of our workflows.
HI Bojan.. Maybe you can help me also??????
Bojan.. So Thank you for your feedback.. Ive had a conversation out there for a minute on this. I like it. Infor is listening. Thats awesome. So how can we get involved in this limited availability program. WE are very interested.. Very. As are 1000 other customers .. where's the sign up list Bojan...? thx, Joe
What qualifies someone to take part in the BETA testing group???? Can you please share a link??? I have googled a little.. I am sure Dan will get 1000 hits on this… Can you share a link?
We
strongly discourage
using the Data Lake to achieve
real-time or near-real-time outcomes
. For example, querying the Data Lake every 15 seconds, as someone suggested, goes against our best practices and may have significant implications on your Compass licensing. Please reach out to your Infor representative to get in touch with one of our technical consultants who can help assess your use cases and guide you toward the right tools and architecture.
So Bojan.. what does this really imply?
strongly discourage using the Data Lake to achievereal-time or near-real-time outcomes
Is there an agreement we have signed that says we can't repeatedly access data via the REST API's???
You say best practices. In what sense are we violating that? Thx, Joe
By the way.. I in no way represent my companies opinion on this. This is my personal opinion.
My company is in no way involved in this.
Other than I am investigating methods by which we can stand up Power BI.
Thx, Joe
Hi Joe, thanks for your follow-up.
To clarify, I don’t have access to or visibility into the specific contractual obligations between your company and Infor. What I’m sharing here is a recommendation based on system architecture and best practices.
The Compass API has a quota of 100 calls per minute, and it’s not designed for high-frequency polling or real-time access. The Infor Data Lake is a big data store, not a traditional database or streaming system. When an Infor Application uses the Data Fabric Streaming Ingestion protocol to publish data, data typically lands in the Data Lake within estimated 5 minutes. Applications that haven't yet started to use the Streaming Ingestion protocol, may send data more frequently to Data Lake, and others may batch on longer intervals, but this variability doesn’t justify querying every 15 seconds. You won’t get new data that fast, and polling at that rate may lead to performance issues and service limit licensing implications. You should not treat the Data Lake as a real-time system.
For real-time needs, we’ve built Stream Pipelines that continuously deliver new data as it arrives in the Data Fabric through the Streaming Ingestion protocol. These services are purpose-built for low-latency scenarios.
And as I mentioned previously, our roadmap has upcoming features that will align better to near real-time use cases and more frequent access to data.
I strongly recommend reviewing your solution design with Infor before proceeding. Our technical consultants can help assess your use case and guide you toward the right services and tools. Your company can reach out to their Infor representative to get connected.
Happy to explain further if needed!
For everyone asking how to gain access to the features that are in early adoption under limited availability release, your company should contact your Customer Success Executive or Infor representative and they will be able to provide you more information or connect you further with the correct people. Thanks.
What destinations are supported by the Stream Pipelines?
The Data Fabric documentation covers current Destinations. Check the roadmap for future plans.Supported databasesThese technologies are currently supported as a destination:Amazon Aurora PostgreSQLAzure Databases for PostgreSQLAmazon RDS for SQL ServerAzure SQL DatabaseSnowflake
The Data Fabric documentation covers current Destinations. Check the roadmap for future plans.
Supported databases
These technologies are currently supported as a destination:
Amazon Aurora PostgreSQL
Azure Databases for PostgreSQL
Amazon RDS for SQL Server
Azure SQL Database
Snowflake
Thanks for the question, @Daniel Turner. Support for on-prem Microsoft SQL Server as a destination in Stream Pipelines is not on the short-term roadmap.
If this is important for your use case, we recommend submitting an Enhancement Request (ER) via Concierge. Please include a brief description of your use case, expected data volume and frequency, how the on-prem server is accessed, authentication/security requirements, and which Infor Application/ERP data you intended to consume in Stream Pipelines.
Also, if other customers share this need, having them endorse the ER will help us prioritize the feature based on broader demand.
Bojan.. | Thank You
Sorry can't comment below on your question regarding on-prem SMS QL server support, no reply button. So will write here.
I was able to setup streaming to local MS SQL server DB. For that we setup publicly available name looking for unusual port like 20000. After that inside network it was redirected to local MS SQL server.
Hey,
Do you have some news about this new connector ? Could you elaborate a little more on the new capabilities involved?
This ODBC connector will be available in Microsoft Fabric to connect directly to the Infor LN Datalake ?
Thank
I'm really looking forward to getting this new connector; the JDBC connector is very limiting
If anyone submits ER for that, please share, I will endorse it gladly.
Hi,
Could someone at Infor give us an update on this new connector ? Could you tell us more about the new features it offers?
Will this ODBC connector be available in Microsoft Fabric for direct connection to the Infor LN Datalake?
Hi Florent,
Infor Power BI Connector can extract data from Infor Data Lake, Data Warehouse, and Source Data Access. It is a custom connector, so it requires installation to Power BI Desktop and Power BI Gateway for securing communication between the Infor cloud and Microsoft Fabric. The connector also works as a source for MS Fabric Data Flows.
The connector comes with an ODBC Driver, but the driver is officially supported only for the Power BI Connector. We know that it also works with MS Excel, and we are happy to hear from customers and partners what other supported software you would like to see in the future.
Regarding release timelines… currently, the connector is in the Limited Availability mode, and it can be accessed through the Early Adoption program. So far, we have received very positive feedback from customers, and the connector can be used in production environments. We are working on the next round, which should start at the end of April/beginning of May. In October 2026, it will be under Managed Availability, and once Infor Data Warehouse is in General Availability, the Power BI Connector will be too.
Best regards,
Standa
Thank for the update.
What is "Managed Availability"? How can I sign up? We are currently deploying Infor LN and hope to go live in early 2027. However, we would like to start working on our dashboards/KPIs before then. Therefore, we would be very interested in testing this connector ASAP (oct26 ?), without waiting for a potential "General Availability" release later.
Could you explain the new features that will be deployed with the "Infor Data Warehouse" module in Data Fabric ?
It is like GA, you should be able to purchase the Infor Data Platform Premium Connectivity after our Product Management approval. Since it is a completely new connector, we want to be sure that customers adopt it with the right expectations.
Regarding Data Warehouse, it is a new centralized data store within Data Fabric for curated data models. We will communicate more details in 2026 and early 2027 through our standards channels like Innovation Insights.
Yes, it is a new add-on that will contain the Power BI Connector and the ODBC Driver. Over time, we might include more connectors. We are still working on the licensing, but any cloud customer (new or existing) will be able to purchase this add-on once it is Generally Available.
