Member: Open Automation Software
Product website: www.openautomationsoftware.com/products/data/recip...
Data transfer from SQL Server, SQL Server Desktop (MSDE), Access, Oracle, and mySQL to local and remote OPC Systems.NET Tags and OPC Servers. Transfer data based on event, time of day, or continuously. Runs as a Windows Service and comes with free configuration application to allow on-line modifications from local or remote systems. Activates Windows Service for local database connection for recipes to local and remote Tags.
Use this feature as part of the full OPC Systems.NET suite to provide database data to OPC Clients, .NET applications, and web applications.
Industry Standard Databases – Use the Recipe Connector to connect to SQL Server, Oracle, Access, mySQL and SQL Azure databases
- .NET Applications – The .NET Data Connector provides read and write access to data programmatically via C# or VB code in a .NET application.
- .NET WPF HMI Applications – Use WPF HMI .NET to create HMI visualizations for WPF Smart Clients
- .NET WinForm HMI Applications – Use WinForm HMI .NET to create HMI visualizations for WinForm Smart Clients
- .NET Trending Application – Use Trend .NET for real-time trending for WinForm and WPF applications and historical trending when combined with OAS Data Historian.
- .NET Alarming Applications – Use Alarm .NET for real-time alarming for WinForm and WPF applications and historical alarming with alarm notification via email, SMS text, and voicemail.
- REST – With the REST API Connector you can connect to data sources via the REST API
- Web-based HMI Applications – Use Web HMI to create cross-platform HMI apps
- Web-based Trending Aplicatons – Use Web Trend to create cross-platform trending apps
- Web-based Alarming Applications – Use Web Alarm to create cross-platform alarm apps
- iOS and Android HMI Apps – Use PCL for Android and iOS to create iOS and Android applications for live data.
- Data Historian – With OAS Data HIstorian you can log data to SQL Server, Oracle, Access, mySQL, SQL Azure and CSV files.
- Reports – With OAS Reports you can create reports from OAS data logging products or other databases. Generate reports as Word, Excel, PDF, HTML or Email.
- Universal Driver Interface – Use C# or VB.NET to integrate your own data model into OAS for realtime data access.
- Allen Bradley – Use the Allen Bradley IoT Driver to connect to ControlLogix, CompactLogix, GuardLogix, Micro800, MicroLogix, SLC 500, and PLC-5. Add Allen Bradley Data Historian to log data to industry standard databases.
- Siemens – Use the Siemens IoT Driver to connect to S7-200, S7-300, S7-400, S7-1200, and S7-1500. Add Siemens Data Historian to log data to industry standard databases.
- Modbus – Use the Modbus IoT Driver to connect to Modbus TCP, Modbus RTU, and Modbus ASCII all supported on Ethernet, RS-232 Serial, and RS-485 Serial. Add Modbus Data Historian to log data to industry standard databases.
- MQTT – With the MQTT IoT Connector you can subscribe to MQTT Brokers.
- Amazon Web Services – With the AWS IoT Gateway driver you can subscribe to AWS for live data updates.
- Excel – Use the Excel Connector to use Microsoft Excel as data source
- Industry Standard Databases – Use the Recipe Connector to connect to SQL Server, Oracle, Access, and mySQL databases
- Industry Standard SCADA Systems – Use the Universal Data Connector to connect to Wonderware, WinCC, RSView and Cimplicty
- OPC Client – Use the OPC Client Connector to connect to third party OPC Clients
- OPC Servers – Connect to OPC UA and Classic OPC DA 2.0 and 3.0 OPC Servers. Use the OPC Tunnel Connector to automatically transfer data from any Data Source to third party OPC Server or OAS IoT Driver.
- Microsoft Azure – Use the SQL Azure Data Logging and SQL Azure Alarm Logging products to connect to Microsoft Azure SQL Databases
- Microsoft Azure IoT Data Hub – Transfer any Data Source to Azure IoT Data Hub using the OPC Tunnel Connector