Import the data

Ramusmartguy

20-01-2020

I have an external database connected and i want to import some data into it. I have the data in local excel file. Is there any workflow reference or docs how to do this. 

Accepted Solutions (1)

Accepted Solutions (1)

Milan_Vucetic

MVP

21-01-2020

Hi Ramusmartguy,
assuming that you can query external database via FDA connector.

If this is the case, you should create data schema of external table  in AC and then in workflow read data from excel and write to the newly created schema/table. Data will be reflected on external database.

 

There is an example of that schema:

milanv69354962_0-1579596809006.png

 

First blue line is hiding internal name of your FDA connector.

Second blue line is hiding database_schema.table_name in external database.

 

Regards,

Milan

Answers (2)

Answers (2)

Milan_Vucetic

MVP

30-01-2020

Hi @Ramusmartguy 

 

yes,  it will just update the address on the existing record in that case.

 

Regards,

Milan

Milan_Vucetic

MVP

29-01-2020

Hi @Ramusmartguy ,

 

that is not complicated, all you need is the good reconciliation key.

milanv69354962_0-1580291632666.png

So, in first step read data from Excel and in last set configuration like this:

milanv69354962_1-1580292355729.png

 

It is important to pick good reconciliation key (or more) .

 

Regards,
Milan