General information on datasources
TDE enables you to handle different logical categories of elements addressing a common underlying topic.
Such different categories (transportation modes, network, demand, etc.) are associated to the concept of datasource.
All datasources are compliant with the naming rule: DS_string.
The suffix string give you a dry indication about the datasource scope.
For example, DS_SCEN is associated to scenarios information.
A datasource value is a string that consists of two parts:
"[storage-type]:[storage-address]"
-
[storage-type]: see the Prefix storage type column in the next table.
-
[storage-address] a valid file system path, or a DB connection string, or web server URI.
Supported data storage formats for input and output are:
Prefix storage type | Format | Description |
---|---|---|
txt |
Text file |
Simple text file formatted as a CSV file |
bin |
Binary file |
TDE binary file |
visum |
Visum text files |
Set of Visum data text files (.net, .dmd, .xml) |
visumcom |
Visum binary file |
Visum data binary file (.ver) (Visum 13 or later; input only) |
postgresql |
PostgreSQL database |
PostgreSQL with PostGIS extension |
shape |
Shapefile |
Standard shapefile with data (.shp, .dbf) |
webservice |
|
|
commandline |
|
|
sqlite |
|
|
Important: sqlite is NOT production ready, and txt and shape are at anexperimental level on few datasources.
The possible values of the parameters are:
-
For physical files: the parameter is the path of the input file, including the file name without the extension.
-
For DB: the parameter is the DB connection string.
-
For Web resource: web server URI.
-
Special values:
-
-2: the data related to the datasource are ignored (default value).
-
-1: the data related to the datasource are loaded by DS_MAIN.
-
Example 1
txt:C:\Users\alessandro.stazi\Desktop\ISO_standards
Example 2
DS_NETS=-2
Example 3
postgresql:Server=localhost;Port=5432;Uid=userid;Pwd=password;Database=DB_XXX;CommandTimeout=3600
The next image shows the DataSource tab in the TRE GUI:
For the complete list of datasources, see → List of datasources.