NEW: API Connector - Asana - Added new tables / endpoints: SubTasks, WorkspaceTasks, get_subtasks, get_workspace_tasks and search_tasks endpoints (Advanced Serverside Filter)
NEW: API Connector - Asana - Enabled pagination for all endpoints to avoid error: The result is too large. You should use pagination
NEW: API Connector - Google Ads - Read / Write Google Ads Account data (e.g. Campaigns, Keywords, Performance Metrics using GAQL)
NEW: API Connector - Google BigQuery - Added support for JSON Key file in Service Account authentication
NEW: API Connector - Google BigQuery - Expose timestamp column as DateTime (Alternate way to insert data in TIMESTAMP column)
NEW: API Connector - Google Calender - Added support for JSON Key file in Service Account authentication
NEW: API Connector - Google Drive - Added list_parent_items endpoint to search under a specific folder or do recursive scan for a specific file types
NEW: API Connector - Google Drive - Added support for JSON Key file in Service Account authentication
NEW: API Connector - Google Drive - Added upload_file_overwrite endpoint with option to overwrite / fail file if exists
NEW: API Connector - Google Sheets - Added support for JSON Key file in Service Account authentication
NEW: General - Add new function FUN_CALC (e.g. <<1|~|Add|~|5,FUN_CALC>> )
NEW: General - Add Q, QQ, QQQ, QQQQ (Quarter 4, 04, Q4, 2015-Q4) and WK (Week Number) format specifiers for TO_DATE and TO_DATETIME functions
NEW: General - New Placeholder function FUN_THROW_IF (Throw error if condition match)
NEW: General - New placeholder functions FUN_PROPERCASE (e.g. [my name] to [My Name])
NEW: JDBC Bridge Driver - Add support for BLOB / CLOB columns
NEW: JSON / XML / CSV Driver - OAuth Connection - Add support for JSON Key file in Google Service Account Option (*.json / *.p12 file extensions now supported)
Bug fixes
FIX: All Drivers - Date is reported as DB_DATE instead of DT_DBDATE
FIX: Data Gateway - JDBC Driver reports numeric as string type
FIX: Data Gateway - OPENQUERY hangs when DT_TEXT / DT_STR (8000+) datatype found in certain sequence
FIX: Data Gateway - Salesforce Driver - Error Issue with large blob fields (DT_NTEXT) - Protocol error in TDS stream
FIX: Data Gateway - Salesforce Driver, API Driver - New Version detects Large String as ntext / text (legacy type) rather than nvarchar(max) / varchar(max)
FIX: Data Gateway - You may get misleading error when Dasource name not found - You get [cannot obtain columns rowset from OLE DB provider] instead of [Database xyz not found]
FIX: JDBC Bridge Driver - Duplicate catalogs reported in some apps like Power BI and no tables listed under it (e.g. empty "default" nodes listed many times)
FIX: JDBC Bridge Driver - Treat datatype as string Rather than throwing error in objectToInt - java.lang.NullPointerException if underlying JDBC driver fail to report correct type in some cases
FIX: Salesforce Driver - Bool, Integer, Numeric fields showing null when Bulk API Mode is turned on