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