Expose AnySQL Modeler JDBC connection as live API — is this possible?

Question

Context:

We have an Enterprise Location defined in Infor OS Portal with a JDBC connection to an on-prem SQL Server datamart (DWD_Datamarts), currently used successfully inside AnySQL Modeler to build models (e.g. select * from Dim_Vendedores) that preview correctly against live data.

What we're trying to do:

We'd like to query this connection's tables on-demand from an external client/application (via a REST call), without replicating the data into Infor Data Fabric's Data Lake. Our data changes frequently and we don't want a batch-loaded copy — we need live, pass-through access, ideally still routed through Infor OS (API Gateway / ION) rather than connecting straight to the SQL Server box.

What we've already checked:

* API Gateway → API disponible: none of the existing app sets/proxy endpoints (M3, ION, BIRST, etc.) expose this connection. Calling arbitrary paths against the ION API Server returns "No such proxy endpoint".
* AnySQL Modeler → "Generar Metadatos" / "Generate Metadata": this only creates a Data Catalog object in Data Fabric that then needs to be populated/loaded (i.e., replication) — it does not expose a live queryable endpoint.

Question:

Is there any supported way in Infor OS/CloudSuite to expose an Enterprise Location JDBC connection (the kind used by AnySQL Modeler) as a live, queryable REST endpoint through API Gateway or ION — without going through Data Lake replication? Or is Data Lake replication the only sanctioned path for this kind of connection?

Any pointers to documentation, a different Infor OS module we haven't checked, or confirmation that this simply isn't supported, would be hugely appreciated.

lopdav0 · Answer

Hi Fabiano, thanks for the reply!

We're actually on M3 (not LN), but to be precise — the ERP itself (M3 or LN) isn't really the point here. The data we're trying to reach doesn't come from M3's or LN's own business objects; it comes from an external SQL Server datamart that's linked into Infor OS through an Enterprise Location (JDBC connection), and is currently only consumable from inside tools like AnySQL Modeler.

So regardless of whether the underlying source is M3, LN, or any other system "linked" via an Enterprise Location connection, our question is: is there a way to expose that Enterprise Location's JDBC connection itself as a live REST endpoint (through API Gateway or ION), rather than relying on an ERP-specific API (like M3 API or LN API REST) or replicating into Data Fabric's Data Lake?

Hope that clarifies the scope a bit — happy to share more details about our Enterprise Location setup if useful.

Fabiano Silva · Answer

Could you confirm you are using Infor LN CE? Because you can use the LN API REST

Copyright © 2026 Infor. All rights reserved.