This is preliminary documentation and is subject to change.

Introduction to connectors

This topic will help you learn how the connectors wrap access to targeted data systems and how they handle schema retrieving and read/write requests.

Connections

A connector defines the access and authentification informations needed to establish a connection. These platform-dependent informations will be input in the dedicated dialog box and stored in a connection object.

File Systems

Delimited Text File

-

Excel File

-

Delimited Text File

-

Xml File

Server-based Dbms

Mysql

-

Oracle

-

PostgreSQL

-

Sql Server

File-based Dbms

Microsoft Access

-

Sql Lite

-

Sql Server CE

Data Services

OData

Schema requests

The underlying database schema is dynamically retrieved each time a connection is opened and stored in a platform independant model.

  Caution

The schema details will be saved when a mapping is made with the transfer model.

Read requests

Write requests

Transactions

Bulk insert