Data Management & Integration

Accounting / ERP Connector Software

  • Windows Service Connector Application with Database Installed on the Client's Server / VM
  • Locally Managed SQL-Lite Database Files for Easy Backup and Management
  • Easy Upgrade Mechanisms for Windows Service / Desktop App
  • Desktop Application Installed for Relevant Users
  • Works Great in Remote Desktop Environments (RDP)
  • Built In Scheduler for Import / Export / EDI Tasks
  • Maintains Adapters for Multiple Accounting / ERP Systems
  • Built In Management for Sales Orders, Purchase Orders and Account Payments
  • Built In Management for Datasets (see below)
  • Automatic Email Notifications For Alerts
  • Secure Links to TOTECS and SQUIZZ.com over HTTPS

Accounting / ERP Adapters

  • Prebuilt Adapters for Supported Accounting / ERP Systems (see integrations)
  • Generic Adapter for Custom Data Sources (Ie, Accounting Systems / ERP Systems / Business Software / SQL Server / ODBC / Web Services APIs / XML / Excel / CSV)
  • Automatic Email Notifications For Adapter Related Alerts
  • Secure Linkages to TOTECS and SQUIZZ.com Managed Through Adapter Keys
  • Adapter Level Error and Debug Logging

Exporting / Importing Data From Accounting / ERP to TOTECS

  • Structured Export Routines as Specified In the eCommerce Standards Documents
  • Set Source and Destination Data Field Mappings
  • Set Data / SQL Query Conditions
  • In Built Data Export Testing Tool to Verify Queries
  • Merge Data from Other Adapters using Data Routing
  • Manually Run Imports / Exports or Add To Scheduler
  • Configure Both Live and Scheduled Imports / Exports

Managing Product Datasets

  • Create an Unlimited Set of Databases To Set and Store Product Catalogue Data
  • Set / Store Data For Product Details
  • Set / Store Data For Product Category Trees
  • Set / Store Data For Product Attributes (uses product names for automatic data introspection)
  • Set / Store Data For Product Combinations (uses product names for automatic data introspection)
  • Set / Store Data For Related Products
  • Filter Any Data Field For Easy Management
  • Copy and Paste to Excel Feature
  • Fill Down Feature
  • Use Data Routing or SQL Merge Tools for Imports / Exports

Sales and Purchase Order, Payments Management

  • Realtime Grid View Showing Live Activity
  • Manual Override for Posting to Accounting / ERP
  • Reimport Tool for Posting to Accounting / ERP
  • Document Inspection (view all data fields and lines)
  • Document Modification (for testing and verification)
  • Automatic Email Notifications For Document Related Alerts