Overview

The 'Extract' objects allows us to extract information into our repository from external sources that we have registered as data sources.

Development Environments

AP DataPipe Engine - MySQL

The ARPIA Platform DataPipe Engine is focused on our data sources that are connected via a MySQL database

When need to select the table we want to extract the data from and the destination table, if there is no destination table we can click the button "CREATE TABLE IN REPOSITORY" to create a similar table, this will open the "Create Table in Repository".

Here will be shown the SQL to create the table in our Destination Repository, its mandatory to design a primary key to be able to create the table, after we finish with this process we can hit on create table and the new table will appear in the options of our destionation repository. After we select it the fields mapping wll appear under and we can clck on get fields to automatically map the fields.

The next step would be to configure the DataPipe Settings