XDBC4ALL

Open Source Software for
Extracting, Transforming and Loading
any kind of data

Introduction

What's in a name?

The goal of the XDBC4ALL project is to build Data Access Objects implementing a common interface. The first thing that is specified in the XDBC4ALL interface is the format of the extracted data. XDBC4ALL chose for XML

Next to the data format, the standard interface also defines the methods that can be used for accessing the data, pretty much as JDBC does. In this sense - although we have to stay very modest - the projects tries to created some kind of "extended JDBC". This is where the XDBC prefix comes from.

The postfix of the projects name refers to the product that it is part of: ETL4ALL. ETL4ALL is an ETL (Extract-Transform-Load) tool commericalized by IKAN Software NV. This produkt allows to combine and transform data from virtually any to any data source, in an extremely user-friendly way. It's data extraction and data loading modules have been made available under GPL, and resulted in the XDBC4ALL project.

Which data sources are supported?

Data source	Read access	Write access
Relational databases	Yes	Yes
XML files	Yes	Yes
CSV files	Yes	Yes
Xindice database	Yes	Yes
Microsoft Excel	Yes	Yes

Why using XDBC4ALL?

Uniform access to different data sources allows changing data source at any time at no cost.

Using XDBC4ALL helps you saving time, as you do not have to take into account the pecularities of different more or less exotic data sources.

Using XDBC4ALL helps you saving trouble, as you use highly tested modules.