Installing the eConnect components
Add the SQL stored procedures that your service uses to create, update, and delete documents. Also, add eConnect Transaction Requester metadata used when retrieving documents and summary documents. To install the eConnect components, complete the following steps:
Copy your SQL files to the Dynamics GP data server.
Copy your SQL script files to a folder on your Dynamics GP data server. This is the SQL server that is managing Microsoft Dynamics GP data.
Open Microsoft SQL Server Management Studio on your Dynamics GP data server.
Open the SQL script files that installs your SQL stored procedures.
In the File menu, point to Open, and then choose File. From the Open File window, navigate to the folder where you copied your SQL script files. Typically, you will have a separate SQL script file for each create/update, delete or void stored procedure that you created. To begin the install, double-click a SQL script file. The SQL script opens in the query window.
Specify the company database.
In the list of databases, specify the company database of the company where you plan to install your service.
Run the SQL script.
From the Query menu, choose Execute.
Hint: If you have more than one SQL script file that installs a SQL stored procedure, repeat the last three steps for each file.
Run the SQL script that adds metadata to the Transaction Requester.
In the File menu, point to Open, and then choose File. From the Open File window, navigate to the folder where you copied your SQL script files. Double-click the file that contains the script you created to add document and summary document metadata to the eConnect Transaction Requester. The script opens in the query window. In the Query menu, choose Execute.
Run the SQL script files for each company.
If your service can include data from other company databases, you need to install the SQL stored procedures and Transaction Requester metadata to each company database.
To install to another company, go back to the step where you specify the company database. Select the company database. Next, complete the steps where you run the SQL scripts that install your SQL stored procedures and Transaction Requester metadata. Repeat these steps for each company that works with your service.
Run the SQL script that adds your custom error codes.
In the File menu, point to Open, and then choose File. From the Open File window, navigate to the folder where you copied SQL script files. Double-click the file that contains the the script you use to add custom error information to eConnect. The script opens in the query window. Open the Query menu and choose Execute. The script adds the error codes and error messages to the taErrorCode table of the DYNAMICS (system) database. If you are using a multitenant environment, repeat this for the system database that is used for each tenant.