Open Endicia and select Edit > Preferences > Data Source and Post-Back tab
Under Source Data > Order Lookup click Configure
Under Data Source click New to open the Data Connections Setup Wizard and make the following selections/entries:
  • Shipping data connection method: ODBC Connection
  • ODBC Data Source: select the name of the ODBC connection you defined
  • User Name & Password: enter your Presidio database User Name & Password
  • Create SELECT Statement Choose a table: dbo.vwShipIntegrationSource
  • Choose the Order Number field: sLookUpJobSeq
In the Connected Fields section, map the 2 fields on the Package Details tab as shown below:

Click the Edit Service Codes button next to Service and make the following entries

Service MethodCode
First-Class Package Service101
Priority Mail130
Media Mail104
Map the 10 fields on the Recipient Address tab as shown below:

Click OK to complete the Import Setup.