# IQMS ERP API: DELMIAworks Integration Options Compared

> Source: https://netray.co/erp-help/iqms-erp-api-delmiaworks-integration-options
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: ERP Help

## Short answer

IQMS was renamed DELMIAworks after Dassault Systemes acquired it, so searches for the IQMS ERP API lead to the DELMIAworks integration options: a web API, read-only access to the Oracle database, import and export utilities, EDI, and middleware. The right option depends on whether you read, write or both, and on how much upgrade risk you accept.

## Kind

advanced

## System

delmiaworks

## Erp

DELMIAworks (formerly IQMS)

## Module

Integration / Database

## Query

iqms erp api

## Alternate Queries

- delmiaworks manufacturing erp formerly iqms
- iqms oracle database access
- iqms integration options

## Applies To

IQMS and DELMIAworks releases. Older IQMS versions have fewer API options; check your version with the vendor.

## Steps

### Choose the integration route

**Items:**

- Confirm your version and whether it is called IQMS or DELMIAworks in your contract.
- List the use cases: reporting, shop floor data, quality, eCommerce, EDI, CAD or PLM.
- For reading data at scale, use a read-only database account on a replica.
- For transactional exchange, use the vendor web API or supported import routes.
- For partners, use EDI or a middleware product that already supports the system.
- Test everything in a non-production instance.
- Plan for retesting at each upgrade.

## Sections

### The history in one paragraph

**Body:**

IQMS was a manufacturing ERP built on an Oracle database, widely used in plastics and discrete manufacturing. It became DELMIAworks under Dassault Systemes, which also owns SolidWorks, so integration with design tools is a vendor theme. Old documentation and forum posts use the IQMS name; new ones use DELMIAworks.

### Route 1: web API

**Body:**

The web API is the cleanest route for operational integration because it goes through business logic. Obtain documentation and licence terms from the vendor, use a dedicated credential, and design for retries.

### Route 2: database access

**Body:**

Because the system sits on Oracle, analytics and AI tools often connect read-only through ODBC or JDBC. This is quick and powerful, but table names and relationships are not a stable public contract, so use views you control and test after upgrades. Do not write to tables directly.

**Code:**

-- Example pattern: create a read-only reporting user (adapt names to your site)
CREATE USER reporting_ro IDENTIFIED BY "change_me";
GRANT CREATE SESSION TO reporting_ro;
GRANT SELECT ON <schema>.<approved_view> TO reporting_ro;

### Route 3: imports, EDI and middleware

**Body:**

For customer and supplier exchange, EDI is the standard route, and middleware vendors often have connectors. Import and export utilities fit one-off or batch loads such as items or price lists.

## Pitfalls

- Searching only for IQMS documentation and missing newer DELMIAworks material.
- Hard-coding table names into integrations without a view layer.
- Writing directly to Oracle tables.
- Giving the integration a DBA-level account.

## Ai Angle

Because the data sits in a relational database, a private AI layer can answer questions against read-only views, explain results, and show the SQL. Netray builds this on-prem with open-weight models so no ERP data leaves the plant network.

## Faq

### Is IQMS the same as DELMIAworks?

**Answer:** Yes. IQMS was renamed DELMIAworks after the product moved to Dassault Systemes, so older IQMS material often still applies with updates.

### Is there an IQMS API?

**Answer:** Newer releases offer a web API, and sites also integrate through the database, imports, EDI and middleware. Confirm what your version supports with the vendor.

### Is read-only SQL access safe?

**Answer:** Yes if you use a restricted account on a replica or approved views. Writing directly is what causes data integrity and upgrade problems.

## Search terms

iqms erp api, delmiaworks formerly iqms, iqms oracle database, delmiaworks integration options, iqms integration, delmiaworks manufacturing erp, delmiaworks odbc

---
Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json