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.
- Execute this script from your source database server.
- 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 |