IfOverview
The Module Dataset is composed by the The Datasets Data Server Service that will receive the request from the various modules, access the data sources, and reply to the requests.
In order to fully leverage the Module Datasets is important to understating various advanced aspects such as: managing parallel requisitions, doing synchronous or asynchronous requests, mapping data to tags in the server side or in the client side the application, performance and others items.
If you are new user, or in simple projects, it's not necessary to review all those concepts up front, before using the Dataset Module. But, if you are deploying projects in production that required exchange of data with SQL database is recommended the you review those topics and how they may apply to specific solution architecture.
Overview
This document provides an in-depth guide on how to establish connections between your FactoryStudio project and Microsoft Excel files. Excel is a widely used spreadsheet application, and integrating data from Excel files can greatly enhance the flexibility and efficiency of your project. The ability to connect to Excel files allows for seamless data exchange and collaboration between your project and various data sources.
This guide will cover various methods for connecting FactoryStudio with Excel files, including the use of ODBC (Open Database Connectivity), the ODBC Microsoft Excel Driver, configuring ODBC with a Data Source Name (DSN), and utilizing OleDB. Each of these techniques offers unique advantages and capabilities, ensuring that you can find the most suitable approach for your specific needs.
On this page:
| Table of Contents | ||
|---|---|---|
|
Execution Process and Interface with Databases
The Dataset module, specifically the "TRunModule.exe (Dataset)" process, reads all project configurations relevant to this module but does not directly interface with the databases. Database access services are provided by TServer, with the Dataset module consuming these services.
In this section...
| Page Tree | ||||
|---|---|---|---|---|
|