Step 5.3 SQL Script for Linked ETL database
This is a new feature for EFP r1.3.
It's only available if you install EFP with Linked Server Option.
It's only available if you install EFP with Linked Server Option.
- Login to the source database server (where the ERP database(s) are hosted) with administrator privileges.
- You will then see a new database named like pcETL_LINKED_XXXX on your source database server.
- Grant the EFP Service account(Best practice) Database role membership as db_owner on the newly created pcETL_LINKED_XXXX database.
- Make sure that the EFP Service account has read access to the source database (ERP database).
Button | Description |
---|---|
Save to file | Possible to save it as a SQL file |
Clipboard | Possible to copy it to a new SQL query window |
Continue | Go to next step |
Cancel | Terminate the action |