


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.
Solved! Go to Solution.
Views
Replies
Total Likes
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
Views
Replies
Total Likes
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
Views
Replies
Total Likes
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.
Views
Replies
Total Likes
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
Views
Replies
Total Likes
Views
Replies
Total Likes
yes, it will just update the address on the existing record in that case.
Regards,
Milan
Views
Replies
Total Likes
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.
Views
Replies
Total Likes
Views
Replies
Total Likes