Preparing the databases, Creating a data source name (dsn) – IntelliTrack Inventory Shipping Receiving Picking (ISRP) User Manual
Page 91
Chapter 5
Lookups
63
ISRP integrates with UPS OnLine® WorldShip® in two ways:
1.
WorldShip will accept ISRP data through an “import map” that you
must create. This map associates the correct shipping data fields in
ISRP with the correct fields in UPS OnLine WorldShip. This process is
called “keyed import” in UPS OnLine WorldShip.
2.
ISRP will accept UPS OnLine WorldShip data through an “export
map” that you must create. The export map will allow you to associate
the correct shipping data fields in UPS OnLine WorldShip with the cor-
rect shipping data fields in ISRP. This process is called “keyed export”
in UPS OnLine WorldShip.
Important: To integrate IntelliTrack ISRP with UPS OnLine WorldShip,
you must be a UPS customer using UPS OnLine WorldShip 6.0 through
10.0 software to process your UPS shipping activities. The instructions
and examples in this section follow UPS WorldShip v10.0.
To use the WorldShip Integration process successfully, be sure that you
have:
•
Entered all shipping methods used with UPS in the Shipping Methods
Lookup table in ISRP. For more information about shipping methods,
please refer to
•
Entered the correct Ship To information in the Ship To IDs tab of the
Customers form in ISRP. For more information about entering cus-
tomer shipping information, please refer to
Preparing the
Databases
Preparing ISRP for UPS OnLine WorldShip integration requires:
•
Creating a Database Source Name (DSN) for the ISRP database, and
•
Setting up import and export maps in UPS OnLine WorldShip.
Prior work with databases is helpful. If you are not experienced in working
with databases, and are unsure about any of the steps involved in the setup
process, contact your network administrator for help.
Creating a Data Source Name (DSN)
Before you begin setting up the import and export maps, you must create a
Data Source Name (DSN) for your ISRP database, so that UPS OnLine
WorldShip and IntelliTrack ISRP can communicate and share data with