In MX-Developer you can use the MxAdapter designer to create a data access layer for an application. It provides simpler access to different data sources and data manipulation within the data source without having to deal with the complexities inherent in this access. In simpler words the MxAdapter hides the complexity of the underlying data source from the developer. Another important feature of the MxAdapter is a uniform configuration of different data sources, which is achieved with abstraction of data sources supported in it. The MxAdapter supports two standard data source:
- MSSQL 2005
- Oracle 9i and higher
In addition to that, the developer can download MxAdapter extensions for:
- Web services,
- MS Access,
- PostgreSQL,
- MySQL
- OPC and
- iHistorian data source.
The behaviour of the MxAdapter is standardized. This allows joining data from different data sources such as SQL or Web services together, which provides the end-user with a better overview of the data, improves analytics, and simplifies business decisions.
In This Section
Instructions on how to create MxAdapter component.
Overview of data sources and their features.
Describes the expression designer alone with all its functions and variables.