About the Easysoft ODBC-QOnline Driver
The Easysoft ODBC-QOnline Driver provides real-time access to QuickBooks Online data from any application that supports ODBC.
In this section:
ODBC API and scalar functions
API functions
Use this table to find out what ODBC API functions the Easysoft ODBC-QOnline Driver supports:
| Function | Status |
|---|---|
Supported |
|
Supported |
|
Supported |
|
Supported |
|
Supported |
|
Supported |
|
Not supported |
|
Not supported |
|
Supported |
|
Supported |
|
Supported |
|
Supported |
|
Not supported |
|
Supported |
|
Supported |
|
Supported |
|
Supported |
|
Supported |
|
Supported |
|
Supported |
|
Supported |
|
Supported |
|
Supported |
|
Supported |
|
Supported |
|
Supported |
|
Supported |
|
Supported |
|
Supported |
|
Supported |
|
Supported |
|
Supported |
|
Supported |
|
Supported |
|
Supported |
|
Supported |
|
Supported |
|
Supported |
|
Supported |
|
Supported |
|
Supported |
|
Supported |
|
Supported |
|
Supported |
|
Supported |
|
Supported |
|
Supported |
|
Supported |
|
Supported |
|
Supported |
|
Supported |
|
Supported |
|
Supported |
|
Supported |
|
Supported |
|
Supported |
|
Supported |
|
Supported |
|
Supported |
|
Supported |
|
Supported |
|
Supported |
|
Supported |
|
Supported |
|
Supported |
|
Supported |
|
Supported |
|
Supported |
|
Supported |
|
Not supported |
|
Supported |
|
Supported |
Scalar functions
The Easysoft ODBC-QOnline Driver supports a number of scalar functions:
Use either the SQL-92 or ODBC syntax with scalar functions. For example:
SELECT
Invoice_Id,
Customer_Name,
EXTRACT(YEAR FROM Due_Date) as "Year"
FROM
Invoice
SELECT
Invoice_Id,
Customer_Name,
{fn EXTRACT(YEAR FROM Due_Date)} as "Year"
FROM
InvoiceString functions
The Easysoft ODBC-QOnline Driver supports these string functions:
-
ASCII(string_exp) -
BIT_LENGTH(string_exp) -
CHAR(code) -
CHAR_LENGTH(string_exp) -
CHARACTER_LENGTH(string_exp)` -
CONCAT(string_exp1, string_exp2) -
DIFFERENCE(string_exp1, string_exp2) -
INSERT(string_exp1, start, length, string_exp2) -
LCASE(string_exp) -
LEFT(string_exp, count) -
LENGTH(string_exp) -
LOCATE(string_exp1, string_exp2[,start]) -
LTRIM(string_exp) -
OCTET_LENGTH(string_exp) -
POSITION(char_exp IN char_exp) -
REPEAT(string_exp, count) -
REPLACE(string_exp1, string_exp2, string_exp3) -
RIGHT(string_exp, count) -
RTRIM(string_exp) -
SOUNDEX(string_exp) -
SPACE(count) -
UCASE(string_exp)
Numeric functions
The Easysoft ODBC-QOnline Driver supports these numeric functions:
-
ABS(numeric_exp) -
ACOS(float_exp) -
ASIN(float_exp) -
ATAN(float_exp) -
CEILING(numeric_exp) -
COS(float_exp) -
COT(float_exp) -
DEGREES(numeric_exp) -
EXP(float_exp) -
FLOOR(numeric_exp) -
LOG(float_exp) -
LOG10(float_exp) -
MOD(integer_exp1, integer_exp2) -
PI() -
POWER(numeric_exp, integer_exp) -
RADIANS(numeric_exp) -
RAND([integer_exp]) -
ROUND(numeric_exp, integer_exp) -
SIGN(numeric_exp) -
SIN(float_exp) -
SQRT(float_exp) -
TAN(float_exp) -
TRUNCATE(numeric_exp, integer_exp)
Time, date, and interval functions
The Easysoft ODBC-QOnline Driver supports these time, date, and interval functions:
-
CURRENT_DATE() -
CURRENT_TIME[(time-precision)] -
CURRENT_TIMESTAMP[(timestamp-precision)] -
DAYNAME(date_exp) -
DAYOFMONTH(date_exp) -
DAYOFWEEK(date_exp) -
DAYOFYEAR(date_exp) -
EXTRACT(extract-field FROM extract-source) -
HOUR(time_exp) -
MINUTE(time_exp) -
MONTH(date_exp) -
MONTHNAME(date_exp) -
NOW() -
QUARTER(date_exp) -
SECOND(time_exp) -
TIMESTAMPADD(interval, integer_exp, timestamp_exp) -
TIMESTAMPDIFF(interval, timestamp_exp1, timestamp_exp2) -
WEEK(date_exp) -
YEAR(date_exp)
System functions
The Easysoft ODBC-QOnline Driver supports these system functions:
-
DATABASE() -
USER()
Conversion functions
The Easysoft ODBC-QOnline Driver supports supports both the SQL-92 CAST function and the ODBC CONVERT function for conversion between compatible data types.
Data type mapping
The Easysoft ODBC-QOnline Driver maps QuickBooks Online data types to ODBC data types in this way:
| QuickBooks Online data type | ODBC data type |
|---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Finding out more about data types on Windows
If you need more information about a data types, for example, the precision and scale, use Microsoft’s ODBC Test to do this.
-
Download the version of ODBC Test that matches your application’s architecture from:
-
Copy both files to a folder on the machine where Easysoft ODBC-QOnline Driver is installed.
-
Double-click odbcte32.exe.
-
Select Con > Full Connect.
-
Choose your Easysoft ODBC-QOnline Driver data source from the list.
-
Choose Catalog > SQLGetTypeInfo.
-
Either choose SQL_ALL_TYPES=0 (1.0) or a specific data type from the DataType list.
-
Choose Results > Get Data All.