Databases

Total: ~21

Database integration to the likes of MS SQL Server, Oracle, and others is essential to a variety of applications. It is particularly useful for interfacing to track and trace, MES, or other 3rd party systems which may handle process data directly.

Database Connectivity

Connectivity to databases is a standard protocol in the ICONICS solution stack, and a variety of platforms are supported. This integration is frequently used for 3rd party relational database systems integration.

Connecting to SQL Server Databases

An overview of how to connect to and access data from Microsoft SQL Server databases, as well as specifics related to SQL Server as opposed to other databases.

Connecting to Oracle Databases

An overview of how to connect to and access data from Oracle databases, as well as specifics related to Oracle as opposed to other databases.

Connecting to OLEDB Databases

An overview of how to connect to and access data from databases via the OLEDB connector. This connector is useful for other databases not specifically listed individually.

Select Statement Queries

This video explains how to create a SELECT statement for your data source as well as configure a user-defined parameter.

Insert, Update, and Delete Queries

Beyond simple SELECT statements, learn how to integrate INSERT, UPDATE, and DELETE queries into your application, both configuration and runtime use.

Using Stored Procedures

Stored procedures can be accessed and used just like any other SQL query. Learn how to use them including parameterized procedures.

Data Manipulators

Data Manipulators provide powerful direct access queries that can be applied to the SQL database via runtime commanding and automated transactions.