Data Source and Data flow

Data Source

A Data Source in AVEVA Integration Service (AIS) defines a connection to an external system from which data can be read or to which data can be published. Data Sources are created and managed using the AIS Web Administration interface.

When creating a Data Source, the required connection details and authentication information must be provided, along with a descriptive name for easy identification.

Common examples include:

Once created, Data Sources are stored in the AVEVA Integration Service Config API. These configurations are referenced by other AIS components during integration processes.

Data sources supported:

• AVEVA Engineering

• AVEVA™ Diagrams

• AVEVA™ Engineering

• AVEVA™ E3D Design

• AVEVA™ Marine

• AVEVA™ PDMS

• AVEVA™ Plate & Bar Nesting

• AVEVA™ Unified Engineering

• AVEVA Instrumentation

• AVEVA Electrical

• AVEVA P&ID

• AVEVA ERM

• SQL Server

• Oracle

• Excel

• ETAP

• AVEVA PRO II

• AVEVA Process Simulation

• Generic: Not tied to any application. Supported for direct publishing to the data source, but not available for on-demand data access.

Administer Data source

Refer Configuring AVEVA Integration Service for Various Data Sources to create data sources.

Data Flow

The AIS Data API enables integration between AVEVA products and third-party applications. It supports two modes of operation:

• On-Demand Live Data Pull from Data Sources

• Direct Publish to Data Sources

On-Demand Live Data Pull from Data Sources

This mode retrieves data from a Data Source in real time when requested.

Process Flow:

1. Data Request – The user, subscriber, or application makes a request to the AIS Data API specifying:

   • The Data Source name.

   • The type of data required (for example list of tables, specific table data, table schema).

2. Acknowledgment – AIS Data API returns an AcknowledgmentId.

3. Data Retrieval –

   • The Local AIS API, based on the message content, reads data from the specified Data Source.

   • The local AIS receives the message and uploads data to the AIS Data API.

4. Notification – AIS Data API notifies the requester that the requested data is available.

5. Data Download – The requester downloads the data via AIS Data API endpoints and processes or imports it into their system.

   

Direct Publish to Data Sources

This mode allows applications to push data directly to a Data Source for immediate consumption by subscribers.

Process Flow:

6. Data Upload – The user, publisher, or application uploads data to the Data Source using AIS Data API endpoints, providing:

   • Data content.

   • Context information.

   • Expiry time for the data.

7. Temporary Storage – AIS Data API stores the uploaded data temporarily in a database.

8. Broadcast Notification – AIS Data API uses SignalR to broadcast a message to all subscribers of the Data Source. The message includes:

   • Data context.

   • Reference to download the data.

9. Data Download – Subscribers download the data via AIS Data API endpoints and process or import it into their systems.

   

Notes:

• Ensure that Data Source names do not contain special characters (only - or _ are recommended).

• Authentication details must be valid to enable successful connections to the target system.

• Temporary data in Direct Publish mode is removed upon expiry as defined during upload.

• Refer to AVEVA Product compatibility guide for the version number of the product supported.