Print this page
Data Exchange by Verizon Connect (TDE) lets you use data transfer templates
to import data from a variety of file types and export data from Verizon Connect products to a variety of file types
(see the [Template] section for the supported file types).
Each template, when executed,
accomplishes a single data operation, which is called the intent of the template.
These intents include:
- Create - Create data in a TDE table.
- Retrieve - Retrieve data from a TDE table into a file.
- Update - Update data in a TDE table.
- CreateOrUpdate - Update data in a TDE table for each row that exists,
otherwise create a new row for each row that does not exist.
- Delete - Delete data from a TDE table.
Importing and exporting is accomplished using a Web Service that transfers
data based on the contents of a template file. Each template file contains
mappings between published TDE tables and external fields.
Using Data Transfer Templates
The following topics describe how to use Templates in detail:
- Data Types -
describes the data types used in all TDE tables.
- Functions in templates -
describes the built-in and native .NET functions that you can use inside templates.
- Tables -
describes the each of the tables that you can access with templates,
the requirements for each table, and the table columns that are available to you.
- Template Files -
describes the structure and syntax of template files. Each template file contains mappings
between published Verizon Connect tables and external fields.
- Template syntax -
describes the syntax of template files, including how to use external keys and convert date/time values.
- Using the Web Service -
describes how to invoke the Verizon Connect Web Service to create, update, locate, and execute your templates.