This is a new feature for EFP r1.3.
It's only available if you install EFP with Linked Server Option.
  1. Login to the source database server (where the ERP database(s) are hosted) with administrator privileges.
  2. Execute this script from your source database server.
  3. You will then see a new database named like pcETL_LINKED_XXXX on your source database server.
  4. Grant the EFP Service account(Best practice) Database role membership as db_owner on the newly created pcETL_LINKED_XXXX database.
  5. 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
  • efp/tech/installguide/linkedscript.txt
  • Last modified: 2020/09/29 10:03
  • by pcevli