Skip to main content
Ramusmartguy
January 20, 2020
Solved

Import the data

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. 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Milan_Vucetic
Milan_VuceticAccepted solution
Level 9
January 21, 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:

 

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

View in thread

7 replies

Milan_Vucetic
Milan_VuceticAccepted solution
Level 9
January 21, 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:

 

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

Translate
RamusmartguyAuthor
January 28, 2020

Hi Milan,

 

I have the external database connected and schema already exist. I just wanted to import or update the data. I need the steps for that. I am afraid that if i upload anything that will mess with the other data which already exists in the table so just wanted to be careful. 

Translate
Milan_Vucetic
Milan_Vucetic
Level 9
January 29, 2020

Hi @ramusmartguy ,

 

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

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

 

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

 

Regards,
Milan

Translate
RamusmartguyAuthor
January 30, 2020
Great thanks Milan, My next question is lets assume i have loaded all the data ( employeeId, Name, Jobdesc, address etc., ) through insert or update and if next time if i load the data with same process and same workflow ( i have a reconciliation key i.e., primary key as employee id ) so next time if i load next file and the file have the same employeeid which i loaded earlier but the address is changed now. So this workflow will do just update the address OR it will create a new duplicate row with same employeeID and different address. Sorry if i am bothering you with my questions
Translate
Milan_Vucetic
Milan_Vucetic
Level 9
January 30, 2020

Hi @ramusmartguy 

 

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

 

Regards,

Milan

Translate
RamusmartguyAuthor
January 30, 2020

Great thanks Milan for the quick reply. One more question regarding the Data extraction component - my main task is to take the data from the query activity and to upload into some amazon path. In this i can directly use data upload activity right rather than data extraction activity. As data extraction activity will first store the data into local server and then send the data to file upload activity. 

Translate
Terms & ConditionsAccessibility statement

Loading footer...