What’s New
In this version we focused on many bug fixes. Among them most important bug was limitation of only 2000 characters for SQL Query using OPENQUERY statement. Now you can use up to 8000 characters for OPENQUERY and if that’s not enough use EXEC AT statement to send query to Data Gateway. We also made many improvements with our Salesforce Driver so now you can use it along with Data Gateway or any other Reporting / ETL tools.
Version 1.1.4.10904 [Sep 11, 2019]
New Features/Improvements
- NEW: All Drivers – New DSN dialogbox should suggest unique DSN name if already exists (Prevent accidental overwrite)
- NEW: All Drivers – Add support for named parameters for stored procs (e.g. exec webrequest @uri=’https://abc.com’ )
- NEW: Data Gateway – Give Export / Import Settings option
- NEW: Data Gateway – Provide list of database to caller App
- NEW: General – Use default log file name if only folder name is supplied
- NEW: Salesforce Driver – Add Placeholder Engine Support
Bug fixes
- FIX: All API Drivers – Query builders shows Password and Default Attributes on first time launch
- FIX: All API Drivers – RetryInfo not included in Connectionstring or generated SQL
- FIX: All API Drivers – URL JOIN may cause error for decimal values – Query execution error: Input string was not in a correct format.
- FIX: All API Drivers – URL on general tab is wiped out when you use save HTTP Connection
- FIX: All API Drivers – Field names are wrong StatucFieldxxxxxxx and StatucCheckxxxxxx rather than StatusCheckxxxxxx and StatusFieldxxxxxxx
- FIX: CSV Driver – JOIN query fails in CSV driver with invalid format detected
- FIX: Data Gateway – MS SQL Server – Support more than 2000 characters for SQL in OPENROWSET and EXEC – In old version you may get error – Data is invalid if text is longer than 2000 characters
- FIX: Data Gateway – Query with Caching Option hangs
- FIX: Data Gateway – Use of META in WITH clause prevents error in some cases
- FIX: Data Gateway – You may get “The data is invalid” error when the query is too long
- FIX: Data Gateway – You may get Data is invalid error for OAuth Authorization failure
- FIX: Salesforce Driver – When you execute INSERT via Linked Server Query it Inserts row but fails with error at the end
- FIX: Salesforce Driver – Load ConnectionString action throws Object reference not set to an instance of an object.
- FIX: Salesforce Driver – Click on Generate SQL throws Object reference not set to an instance of an object
- FIX: Salesforce Driver – Data is not returned in Excel when you use [From Microsoft Query] option
- FIX: Salesforce Driver – DELETE statement not working
- FIX: Salesforce Driver – Escape sequence not supported (e.g. WHERE name =’Sam\’s’ )
- FIX: Salesforce Driver – OPENQUERY / EXEC AT doesn’t work with DELETE / UPDATE / INSERT
- FIX: Salesforce Driver – SSIS Failed to Generate Metadata due to character encoding issue
- FIX: Salesforce Driver – Using * in SELECT with WHERE is not working