Import / Sql Engine Spec

Background

SqlEngine is a plugin that allows SQLServer to interface with QBO3. Since many clients use SQLServer, it is important that this interface be verified for reliability.

The spec verifies that data from a SQLServer connection can be used to build QBO3 business objects.

Specification

  • Importing Data via the SQL Engine
    • can create an Import File Template
    • can handle uploading a spreadsheet
    • can create an ImportFile record
    • the spreadsheet should be readable from the database
    • can watch remote file locations and import files found
    • should delete the inserted template
Comments