Cloud Connect

CloudConnect

A simple way to connect SQL Server to Infor CloudSuite Industrial for real-time data access, reporting, and integration.

CloudConnect translates native SQL into secure web service calls, allowing your team to work with cloud-based ERP data using familiar SQL tools and syntax.

CloudConnect overview graphic
Overview

What CloudConnect Does

Instead of building custom applications just to access cloud data, users can query, report on, and interact with Infor CloudSuite Industrial directly through SQL Server.

Benefits and Fit

Why It Matters

  • Run ad-hoc queries without custom development
  • Perform read, insert, update, and delete operations through SQL
  • Connect on-premise systems to cloud ERP data in real time
  • Support reporting with Excel, Power BI, and SSRS
  • Use SQL jobs and workflows to monitor data integrity and automate processes

Built for Familiar SQL Workflows

CloudConnect is designed for teams that already know SQL. Permissions can be managed through standard SQL security, while access to ERP data follows the permissions granted to the configured API or automation user.

Common Use Cases

  • Operational and financial reporting
  • Power BI dashboards using live ERP data
  • Integration between local databases and CSI
  • Automated validation, monitoring, and data sync jobs
  • Legacy system modernization using SQL-based integration

Typical Requirements

  • Microsoft SQL Server
  • Internet Information Services (IIS)
  • .NET Framework
  • Infor CloudSuite Industrial automation-licensed user
  • Permissions to the needed IDOs and related services

Request a Demo
SQL Examples

Query SyteLine Cloud Data Like It’s On-Premise

CloudConnect lets teams use familiar SQL syntax to answer real business questions against SyteLine cloud data.

Sales Visibility

Open Sales Backlog by Item

Show open demand by item and calculate backlog value using standard SQL against SLCoitems.

Example Query
select
    Item,
    Description,
    sum(QtyOrdered - QtyShipped) as BacklogQty,
    sum((QtyOrdered - QtyShipped) * Price) as BacklogValue
from SLCoitems
where QtyOrdered > QtyShipped
group by Item, Description
order by BacklogValue desc;

Sample Data
CoNum CoLine Item QtyOrdered QtyShipped DueDate
DC00000106 1 FA-10000 100 100 2019-01-14
DC00000106 2 TA-50000 100 100 2019-01-14

Customer Service

Late Customer Orders

Identify order lines that are not fully shipped and are already past due.

Example Query
select
    CoNum,
    CoLine,
    Item,
    QtyOrdered,
    QtyShipped,
    DueDate
from SLCoitems
where QtyOrdered > QtyShipped
  and DueDate < getdate()
order by DueDate, CoNum, CoLine;

Inventory Visibility

Items with Demand but No Available Stock

Combine inventory and open order demand to highlight shortages that need attention.

Example Query
select
    i.Item,
    i.Description,
    i.QtyOnHand,
    coalesce(d.OpenOrderQty, 0) as OpenOrderQty
from SLItems i
left join (
    select
        Item,
        sum(QtyOrdered - QtyShipped) as OpenOrderQty
    from SLCoitems
    where QtyOrdered > QtyShipped
    group by Item
) d on d.Item = i.Item
where i.QtyOnHand <= 0
  and coalesce(d.OpenOrderQty, 0) > 0
order by d.OpenOrderQty desc, i.Item;

Sample Data
Item Description QtyOnHand
30F 30’ Hurricane – 30F Floor Plan 0
30F 30’ Hurricane – 30F Floor Plan 0

Manufacturing

Open Jobs with Percent Complete

Track production progress directly from SLJobs using released and completed quantities.

Example Query
select
    Job,
    Item,
    QtyReleased,
    QtyComplete,
    case
        when QtyReleased = 0 then 0
        else (QtyComplete * 100.0 / QtyReleased)
    end as PctComplete,
    Stat
from SLJobs
where QtyReleased > QtyComplete
order by PctComplete asc, Job;

Sample Data
Job Item QtyReleased QtyComplete Stat
1 FA-10000 1 0 F
1 FA-10000 1 0 F

Traceability

Link Customer Orders to Production Jobs

Connect customer demand to manufacturing execution using familiar SQL.

Example Query
select
    Job,
    Item,
    OrdNum as CoNum,
    OrdLine as CoLine,
    QtyReleased,
    QtyComplete,
    Stat
from SLJobs
where OrdNum is not null
order by OrdNum, OrdLine, Job;

Executive Reporting

Top Customers by Open Order Value

Create management-ready KPIs from SyteLine cloud data using standard SQL.

Example Query
select
    CoCustNum as CustNum,
    sum((QtyOrdered - QtyShipped) * Price) as OpenOrderValue
from SLCoitems
where QtyOrdered > QtyShipped
group by CoCustNum
order by OpenOrderValue desc;