User Guide : Map Connectors : Source and Target Map Connectors : DataEase
 
Share this page                  
DataEase
DataEase is an accounting package that contains a collection of tables that comprise the database. In a typical DataEase database, there are a series of files with .DBA and .DBM extensions. When DataEase is your source connector, all the database files must be present before the integration platform can connect to the database.
The integration platform supports DataEase versions 4.2 and 4.5.
Tip:  Use a DataEase ODBC driver for connection to more current versions of DataEase.
Connector-Specific Notes
No known limitations.
Property Options
You can set the following source (S) and target (T) properties.
Property
ST
Description
Date Standard
S
This is where you should specify the method your source data uses to store date information. The default for this property is North American MM/DD/YY. The other two choices are International DD/MM/YY and Metric YY/MM/DD.
Version
T
The integration platform can write two versions of DataEase data files. Version 4.5 is the default. If you would prefer your target file to be written as version 4.2, select that from the list.
CodePage
ST
This translation table determines which encoding to use for reading and writing data. The default is ANSI, the standard in the US.
Data Types
The following data types are available:
• Choice
• Date – may contain only a date and the date is formatted as yyyymmdd, for a four-digit year, a two-digit month and a two-digit day. Example: The date January 1, 1999 would read 19990101.
• Fixed point number
• Floating point number
• Number (1-byte)
• Number (2-byte)
• Number (4-byte)
• Number (8-byte)
• Numeric string
• Small Fixed Point
• Small Floating Point
• Text
• Time – may contain only a time.
If you are writing to a new table, you may use any of the available data types from the list that appears when you click the arrow in the Type cell of a field.
If you are appending data to an existing table, the data type of each field uses the data type in the selected table by default.