4D v14.3Importing and exporting data via an ODBC data source |
||
|
4D v14.3
Importing and exporting data via an ODBC data source
Importing and exporting data via an ODBC data source
4D lets you import and export data from or to an ODBC data source. The ODBC protocol (Open DataBase Connectivity) is an interface allowing different applications to communicate between each other using SQL language. An ODBC data source is a permanently open “window” to a document belonging to an application, even when this application is not open. Many applications (databases, spreadsheets, data managers, etc.) allow publishing data as an ODBC source using a specific ODBC driver. Any application supporting the ODBC protocol can read or write data in an ODBC source. The 4D import function allows getting data from an ODBC source while the export function allows inserting data into the ODBC source. Under Windows, the definition of an ODBC source is carried out using the Administrative Tools then Data Sources (ODBC) configuration panel:
Under Mac OS X, the definition of an ODBC source is carried out using the ODBC Administrator program located in the Utilities folder:
For more information on these dialog boxes, refer to the operating system documentation. The concept of importing data from an ODBC source is the same as when importing other types of data (see Importing data from files), with the exception that an intermediary dialog box allowing you to select an ODBC source is used. In the Application environment, importing can be carried out using the IMPORT ODBC command. In the Design environment, it is done using the File menu of 4D. To import data from an ODBC source:
|
PROPERTIES
Product: 4D TAGS ODBC, ARTICLE USAGE
4D Design Reference ( 4D v14 R2) |