Introduction to connectors

[This is preliminary documentation and is subject to change.]

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