Import the data

Avatar

Avatar

Ramusmartguy

Avatar

Ramusmartguy

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)

Avatar

Avatar

Milan_Vucetic

MVP

Avatar

Milan_Vucetic

MVP

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)

Avatar

Avatar

Milan_Vucetic

MVP

Avatar

Milan_Vucetic

MVP

Milan_Vucetic
MVP

30-01-2020

Hi @Ramusmartguy 

 

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

 

Regards,

Milan

Avatar

Avatar

Milan_Vucetic

MVP

Avatar

Milan_Vucetic

MVP

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