Data Management

DATA MANAGEMENT

During our two decades of providing PTMS solutions to warehousing and distribution centers, we have learned that no two businesses will ever have the same—or even similar—data management infrastructures, processes, and requirements. To accommodate this, ScanData has taken a “black box with multiple interfaces” approach. We have isolated our core database and application functionality and built multiple data and operational inputs and outputs. This permits us to “hook up” to customers’ legacy systems (host, WMS, ERP, etc.)—both in batch and transactional pull and push modes—by configuring our inbound and outbound services and applications, all the while leaving our core intact.

COMMUNICATIONS ADMINISTRATOR

ScanData’s Communications Administrator is the primary data management tool for the ESAMS system. No matter how inbound data is transferred between various host systems and the ScanData system, Communications Administrator provides views into the raw data being transferred, the transformed/validated data, and the logging resultant from the data transfer and processing. Customer IS departments (as well as ScanData support personnel) use this application to monitor data transfer as well as troubleshoot and correct various data transfer issues.

INBOUND SERVICES

OUTBOUND SERVICES

· SDS Socket Server is a Windows service that sits on ScanData’s communications server and accepts up to 18 separate connections.

· SDS Web Service exposes standard Web interfaces that support the same functionality as SDS Socket Server but also provides interfaces to manage manifest closes.

· SDS Parsing Server is a Windows service used for implementations with legacy systems requiring file transfer and processing.

· ODBC - When required, ScanData deploys a communications object that natively interfaces with ScanData’s Induction application and opens an ODBC connection to a designated host.

· Database-to-database - When required, ScanData deploys database objects that connect via linked SQL servers to perform the data pull (and push).

· SDS Upload Server allows for configuration of multiple outbound connections. Through SDS Upload Server, files can be scheduled for transfer or can be transferred manually. SDS Upload Server also automaticallly manages carrier-compliant file transfers.

· SDS Archive Server manages data archiving (prior to purge) at pre-determined intervals dependent upon system throughput using a database-to-database connection.

[Click here for communications topology]

[Top]