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. Please reach out to your Customer Success Manager or your Infor contacts to learn more.
Please note the Early Adoption program has limited capacity due to the direct engagement it involves with our development team. However, we’d be happy to take your request and consider you for the next wave of candidates to be enrolled.
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.
