Easysoft Blog

Fri, 08 March 2024

Inserting, updating, and deleting data with the Easysoft Xero ODBC Driver

Code samples, example SQL statements, and SQL Server linked server tips.

updated on: 2024/08/03 11:30 | More

Thu, 28 September 2023

Connecting Microsoft Excel to Xero

Working with Xero data in your Excel spreadsheets.

updated on: 2023/28/09 11:00 | More

Wed, 21 June 2023

Oracle Supported Versions Matrix

How to find out which Oracle version your Easysoft driver supports.

updated on: 2023/21/06 15:30 | More

Mon, 06 February 2023

SQL Server Azure / 2022 Database Ledger Tables from Linux

Ledger tables are a SQL Server feature that have built-in change history and make it apparent if the data they contain has been tampered with. The Easysoft SQL Server ODBC driver enables you to take advantage of ledger tables from Linux and UNIX platforms.

updated on: 2023/02/06 10:30 | More

Mon, 06 February 2023

SQL Server Supported Versions Matrix

How do you find out which SQL Server version your Easysoft driver supports?

updated on: 2023/02/06 10:30 | More

Thur, 24 November 2022

Connect ODBC Applications to Cassandra

Access Cassandra data from Perl, PHP and Oracle.

posted on: 2022/11/24 09:00 | More

Tue, 8 November 2022

Quickbooks Online ODBC Driver

Read, write, and update QuickBooks Online data through ODBC.

updated on: 2022/11/08 10:15 | More

Fri, 17 June 2022

Apache Spark ODBC Driver

Work with Apache Spark data in your ODBC applications.

updated on: 2022/06/17 09:30 | More

Mon, 31 January 2022

Connect PyCharm to SQL Server

Using an ODBC driver to access SQL Server from your PyCharm applications.

posted on: 2022/01/31 15:15 | More

Mon, 06 December 2021

Connect SQL Server to HubSpot CRM

We're developing an ODBC connector for HubSpot CRM.

updated on: 2021/12/06 14:30 | More

Fri, 03 December 2021

Connect ODBC Applications to HubSpot CRM

Access HubSpot CRM data from Perl, PHP and Oracle.

posted on: 2021/12/03 15:30 | More

Fri, 26 Nov 2021

Using Oracle Heterogeneous Services to work with SQL Server data in your Oracle 21c applications.

Using Oracle Heterogeneous Services to work with SQL Server data in your Oracle applications.

posted on: 2021/11/26 14:45 | More

Fri, 26 Nov 2021

Connecting .NET on Linux to an ODBC Data Source

Using .NET with an Easysoft ODBC driver on Linux.

posted on: 2021/11/26 13:15 | More

Wed, 13 Oct 2021

Using ODBC with Salesforce and Okta Single Sign On (SSO)

Using the Easysoft Salesforce ODBC driver with a Salesforce instance that has been integrated with Okta SSO.

posted on: 2021/10/13 15:45 | More

Wed, 06 Oct 2021

Using ODBC with Salesforce and OneLogin Single Sign On (SSO)

Using the Easysoft Salesforce ODBC driver with a Salesforce instance that has been integrated with OneLogin SSO.

posted on: 2021/10/06 15:15 | More

Wed, 22 Sept 2021

Using ODBC with Salesforce and Active Directory Federation Services (ADFS) Single Sign On (SSO)

Using the Easysoft Salesforce ODBC driver with a Salesforce instance that has been integrated with Active Directory Federation Services (ADFS) SSO.

posted on: 2021/09/22 10:45 | More

Wed, 08 Sept 2021

Using ODBC with Salesforce and Azure Active Directory (AD) Single Sign On (SSO)

Using the Easysoft Salesforce ODBC driver with a Salesforce instance that has been integrated with Azure AD SSO.

posted on: 2021/09/08 15:00 | More

Fri, 16 July 2021

Connect SQL Server to HubSpot CRM

We're developing an ODBC connector for HubSpot CRM.

posted on: 2021/07/16 15:15 | More

Mon, 05 July 2021

PayPal ODBC Driver

ODBC connector for PayPal.

posted on: 2021/07/05 15:30 | More

Wed, 23 June 2021

ShipWorks

How to use ShipWorks with an Easysoft ODBC driver.

posted on: 2021/06/23 14:30 | More

Mon, 21 June 2021

Google BigQuery ODBC Driver

Working with Google BigQuery data in some popular applications on Windows.

updated on: 2021/06/21 10:00 | More

Wed, 10 June 2021

Zoho CRM ODBC Driver

We're developing an ODBC connector for Zoho CRM.

posted on: 2021/06/10 15:30 | More

Fri, 19 March 2021

Connecting Oracle to PostgreSQL

How to connect to PostgreSQL from Oracle by using Heterogeneous Services and DG4ODBC.

updated on: 2021/03/19 13:30 | More

Thu, 04 March 2021

Connect SQL Server to SugarCRM

Work with SugarCRM data in SQL Server.

updated on: 2021/04/13 12:30 | More

Thu, 04 March 2021

SugarCRM ODBC Driver

Read, write, and update SugarCRM data through ODBC.

updated on: 2021/04/13 12:30 | More

Mon, 07 December 2020

TDS Server - Use Transact-SQL (T-SQL) Statements To Work With Salesforce Data in SQL Server

The optimal Easysoft solution for using T-SQL with Salesforce.

updated on: 2020/07/12 15:00 | More

Wed, 04 November 2020

SQL Server: Always Encrypted

Keep SQL Server data protected with the Always Encrypted database security feature.

updated on: 2020/04/11 16:00 | More

Tue, 03 November 2020

Using Data Protected with an Azure Key Vault from Linux

The SQL Server ODBC driver now supports Always Encrypted columns that have been secured with an Azure Key Vault.

updated on: 2020/03/11 14:00 | More

Tue, 27 October 2020

SQL Server BULK INSERT from Linux

Initiate a SQL Server BULK INSERT from Linux.

posted on: 2020/27/10 11:45 | More

Mon, 12 October 2020

Connect to QuickBooks Online from Strawberry Perl

Work with QuickBooks Online data from your Perl scripts and applications.

posted on: 2020/12/10 11:00 | More

Thu, 08 October 2020

Connect to QuickBooks Online from Microsoft Office

Work with QuickBooks Online data from your Microsoft Office applications.

posted on: 2020/08/10 15:30 | More

Fri, 31 July 2020

Connecting a 32-bit Application to jBASE

The jBASE ODBC Connector enables 64-bit ODBC applications to access a jBASE instance. Easysoft have a solution if you need to connect a 32-bit application instead.

posted on: 2020/31/07 14:45 | More

Fri, 17 July 2020

Pegasystems Pega Robot Studio

Working with SQL Server data in Pegasystems Pega Robot Studio.

posted on: 2020/07/17 11:30 | More

Thu, 16 July 2020

ReadyCloud ReadyShipper X

Importing and exporting ReadyCloud ReadyShipper X orders via ODBC.

posted on: 2020/07/16 12:00 | More

Fri, 10 July 2020

Copy Data from Salesforce to SQL Server with Spectral Core

Using the Easysoft Salesforce ODBC driver to work with Salesforce data in SQL Server.

posted on: 2020/07/10 12:00 | More

Thu, 09 July 2020

Alibaba Cloud

Database products in the Alibaba Cloud.

posted on: 2020/07/09 12:00 | More

Fri, 03 July 2020

Huawei GaussDB

Client application connectivity options for Huawei GaussDB.

posted on: 2020/07/03 12:30 | More

Thu, 11 June 2020

Connecting SQL Server to a Java Database

Using a linked server with a JDBC driver connection.

posted on: 2020/06/11 15:00 | More

Tue, 09 June 2020

Using SolarWinds Serv-U on Linux with a SQL Server Authentication Database

Authenticate Serv-U users by using a SQL Server backend.

posted on: 2020/06/09 15:45 | More

Fri, 05 June 2020

ServiceNow

ServiceNow can be accessed from an ODBC application on Windows, but what if your ODBC application is running on Linux or UNIX?

posted on: 2020/06/05 15:00 | More

Wed, 03 June 2020

Board

How to use Board with a third party ODBC driver.

posted on: 2020/06/03 15:00 | More

Fri, 29 May 2020

Using MySQL with Oracle Heterogeneous Services

Use Oracle Heterogeneous Services to transparently integrate Oracle with MySQL.

posted on: 2020/05/29 12:00 | More

Wed, 20 May 2020

Connect to QuickBooks Online from Oracle

Use a database link to work with QuickBooks Online data in Oracle applications such as Toad, SQL Developer and SQLPlus.

posted on: 2020/05/15 14:00 | More

Fri, 15 May 2020

Connect APPX to SQL Server

APPX provides an ODBC interface that enables it to use non-APPX data such as information stored in SQL Server.

posted on: 2020/05/15 12:15 | More

Thu, 14 May 2020

Connect SAP IQ to SQL Server

Use a remote server to work with SQL Server data via ODBC.

posted on: 2020/05/14 12:00 | More

Fri, 24 April 2020

SQL Access to MongoDB in the Cloud

Connect ODBC applications such as SQL Server, Office and PHP to MongoDB Atlas.

posted on: 2020/04/24 14:15 | More

Mon, 20 April 2020

Connect to QuickBooks Online from SQL Server

Use a linked server to work with QuickBooks Online data, just as if you were working with data stored in a SQL Server table.

posted on: 2020/04/20 16:15 | More

Fri, 17 April 2020

Connect HP-UX Itanium to SQL Server

The various ways applications running on HP-UX Itanium (or Linux Itanium) machines can connect to SQL Server.

posted on: 2020/04/17 08:30 | More

Mon, 06 April 2020

Tips For Using SQL Server with Salesforce

Guidance on using SQL Server with Salesforce.

updated on: 2020/04/06 10:15 | More

Thu, 21 November 2019

Apache Nifi

Work with ODBC data in Apache Nifi by using Easysoft's JDBC-ODBC Bridge connector.

updated on: 2019/11/21 09:00 | More

Fri, 01 November 2019

Connecting Oracle to SQL Server from Windows

Connect Oracle applications on Windows to SQL Server.

posted on: 2019/11/01 15:00 | More

Thu, 31 October 2019

Enlisting SQL Server in a Distributed XA Transaction

How to access SQL Server in the context of an XA transaction with the Easysoft SQL Server ODBC driver and Oracle Tuxedo.

posted on: 2019/10/31 15:15 | More

Mon, 28 October 2019

Connecting to 4D from Java

Work with your 4D data from Java by using JDBC-ODBC Bridge.

posted on: 2019/10/28 09:00 | More

Tue, 30 July 2019

Transform ODBC Data in CloverDX

Working with ODBC Data in CloverDX.

posted on: 2019/07/30 16:15 | More

Tue, 02 July 2019

Connecting a 64-bit Application to Acomba

Using the Easysoft ODBC-ODBC Bridge to connect a 64-bit application to the 32-bit version of the Acomba ODBC driver.

posted on: 2019/02/07 09:30 | More

Thu, 13 June 2019

A Workaround for the Access 255 Columns Limit

Use a pass-through SQL query to choose which columns are retrieved from an ODBC data source.

posted on: 2019/13/06 14:45 | More

Tue, 11 June 2019

Link to Salesforce Data in Microsoft Access

Using the Salesforce ODBC driver to work with Salesforce data in Microsoft Access.

posted on: 2019/11/06 11:45 | More

Mon, 01 April 2019

Easysoft ODBC Drivers and the ODBCINST Library

Easysoft ODBC drivers on Linux and UNIX are linked against the libodbcinst library.

posted on: 2019/01/04 14:15 | More

Wed, 27 March 2019

Connecting to Lotus Notes from Java

Work with your Lotus Notes data from Java by using JDBC-ODBC Bridge.

posted on: 2019/27/03 15:45 | More

Mon, 25 March 2019

Salesforce API Query Cursor Limits

A user can have up to 10 query cursors open at a time.

posted on: 2019/25/03 15:30 | More

Fri, 22 March 2019

Using OAuth to Authenticate your ODBC Connection to Salesforce.com

The Salesforce.com ODBC Driver now supports OAuth.

posted on: 2019/22/03 15:45 | More

Tue, 19 March 2019

The LD_DEBUG Environment Variable

LD_DEBUG helps you find out why your Linux application is unable to load an ODBC library.

posted on: 2019/19/03 14:30 | More

Fri, 08 March 2019

Connecting PolyBase to Salesforce.com

Integrate your Salesforce data with SQL Server by using PolyBase.

posted on: 2019/08/03 13:30 | More

Tue, 28 February 2019

Connecting Linux and UNIX to Azure SQL Data Warehouse

Access data stored in an Azure SQL Data Warehouse from your Linux or UNIX platform.

posted on: 2019/26/02 12:30 | More

Thu, 21 February 2019

Changing How isql Executes SQL

How to change the ODBC API that isql uses to execute SQL statements.

posted on: 2019/21/02 14:45 | More

Thu, 14 February 2019

Using Pseudo Columns with a Linked Server

Use OPENQUERY rather than 4 part SQL if you want to use pseudo columns.

posted on: 2019/14/02 10:30 | More

Wed, 13 February 2019

What to do if you get an "incorrect bookmark ordinal" error when using SQL Server with our Oracle ODBC Driver

A workaround for this linked server error.

posted on: 2019/13/02 11:45 | More

Mon, 11 February 2019

Connecting SQL Server to Oracle

How to connect to an Oracle linked server from SQL Server.

posted on: 2019/11/02 11:00 | More

Wed, 06 February 2019

Does Your Salesforce Driver Support Bulk Actions?

When to use an Easysoft driver and when to use a tool that uses Salesforce's BULK API.

posted on: 2019/06/02 11:15 | More

Mon, 04 February 2019

SQL Server bcp Utility and the Numeric Data Type

A custom build of the bcp tool is available, which changes its behaviour with regards to the Numeric data type.

posted on: 2019/04/02 11:30 | More

Thu, 31 January 2019

What to do if you get "cannot open shared object file" errors when using the OCI version of the Easysoft Oracle ODBC driver

The OCI version of the Oracle ODBC driver is reliant on the Oracle client software in order to function. The Oracle client is itself reliant on other system libraries to function.

posted on: 2019/31/01 11:15 | More

Tue, 08 January 2019

Connecting to Sage from Java

Work with your Sage data from Java by using JDBC-ODBC Bridge.

posted on: 2019/07/01 12:00 | More

Mon, 07 January 2019

Connecting Oracle to SQL Server over a Secure Connection

How to connect to SQL Server from Oracle over an encrypted network connection.

posted on: 2019/07/01 12:30 | More

Fri, 04 January 2019

Using Salesforce SOQL from Linux

Using Salesforce SOQL from Linux applications such as Oracle, PHP, Python, Perl and OpenOffice.

posted on: 2019/04/01 16:00 | More

Thu, 03 January 2019

Connecting Applications running on Linux to Amazon Relational Database Services (RDS) for SQL Server

Work with SQL Server data stored in the Amazon Web Services (AWS) cloud from Linux.

posted on: 2019/03/01 12:15 | More

Mon, 10 December 2018

SQL Server: "Communication link failure Required SSL (failed to receive packet)"

A solution for Easysoft SQL Server ODBC driver users who get this error.

posted on: 2018/10/12 13:00 | More

Fri, 07 December 2018

Connecting Oracle to Amazon Aurora

How to connect Oracle to a MySQL or PostgreSQL database running on Amazon Aurora.

posted on: 2018/07/12 11:30 | More

Thu, 29 November 2018

Connecting PHP on Linux to Microsoft Access on a Windows Share

Easysoft's Microsoft Access ODBC driver enables you to work with MDB /ACCDB format databases in environments where both Linux and Windows users need to access that database.

posted on: 2018/29/11 16:15 | More

Mon, 26 November 2018

Accessing a File DSN from Java

How to connect to a File Data Source data from Java by using the JDBC-ODBC Bridge.

posted on: 2018/26/11 13:45 | More

Thu, 18 October 2018

Salesforce SOQL from Windows PowerShell

The Salesforce.com ODBC Driver lets you use Salesforce SOQL from a PowerShell script.

posted on: 2018/18/10 16:00 | More

Wed, 17 October 2018

A work around for the "Cursor support is not an implemented feature for SQL Server Parallel DataWarehousing TDS" error

Cursor support in SQL Azure is not the same as in SQL Server. If you're using our ODBC driver to connect to SQL Azure, here's a configuration setting that enables you to work around the "Cursor support" error.

posted on: 2018/17/10 15:00 | More

Tue, 16 October 2018

Attaching a ContentDocument to a Salesforce Custom Object

Using SQL to share a ContentDocument with a custom object in Salesforce.

posted on: 2018/15/10 15:45 | More

Mon, 15 October 2018

Investigating an "ORA 28513" DG4ODBC Error

In this customer case, an Oracle environment variable was preventing Oracle DG4ODBC from loading our ODBC layer.

posted on: 2018/15/10 16:15 | More

Fri, 28 September 2018

Investigating an "ORA 02063" DG4ODBC Error

"ORA 02063" is usually an error you get when your .ora files are set up incorrectly. In this customer case, we tracked the error down to incorrectly set file permissions.

posted on: 2018/28/09 12:45 | More

Thu, 06 September 2018

Salesforce SOQL from Java

Work with your Salesforce data from Java by using Salesforce ODBC driver.

posted on: 2018/06/09 11:45 | More

Wed, 15 August 2018

Tips For Using SQL Server with Salesforce SOQL

Guidance on using SQL Server with Salesforce SOQL.

posted on: 2018/14/08 12:30 | More

Tue, 14 August 2018

Bulk Salesforce Inserts from Microsoft Access

Using the Salesforce ODBC driver to insert multiple Access records into Salesforce in one batch.

posted on: 2018/14/08 11:30 | More

Wed, 25 July 2018

Salesforce SOQL from SQL Server

Use Salesforce SOQL from SQL Server.

posted on: 2018/25/07 14:15 | More

Tue, 24 July 2018

Salesforce SOQL from SAP Crystal Reports

Use Salesforce SOQL from Crystal Reports.

posted on: 2018/24/07 13:00 | More

Tue, 19 July 2018

Salesforce SOQL from Oracle

Use Salesforce SOQL from your Oracle applications.

posted on: 2018/19/07 15:15 | More

Tue, 17 July 2018

Salesforce SOQL from Apache OpenOffice

Use Salesforce SOQL from your Apache OpenOffice applications.

posted on: 2018/17/07 12:45 | More

Mon, 16 July 2018

Salesforce SOQL from Microsoft Office

Use Salesforce SOQL from your Microsoft Office applications.

posted on: 2018/16/07 12:45 | More

Wed, 11 July 2018

SQL Azure: "Database 'XXXYYY' on server '' is not currently available"

A solution for Easysoft SQL Azure ODBC driver users who get this error.

posted on: 2018/11/07 15:45 | More

Mon, 18 June 2018

Getting an ODBC Trace Log from a Linked Server

Getting an ODBC Driver Manager trace log from SQL Server can be problematic. Here are some things to try if you are unable to generate a trace file.

posted on: 2018/18/06 15:15 | More

Fri, 15 June 2018

Eclipse Data Tools Platform

Using the Easysoft JDBC-ODBC Bridge to connect Eclipse Data Tools Platform to ODBC databases such as Microsoft Access.

posted on: 2018/15/06 16:15 | More

Thu, 07 June 2018

Connecting FlySpeed SQL Query to Salesforce.com

Use FlySpeed SQL Query to run SQL statements against Salesforce.com or as a means to test that the ODBC layer you're using to access Salesforce is working correctly.

posted on: 2018/07/06 11:45 | More

Wed, 06 June 2018

Connecting F# to Salesforce.com

The Salesforce.com ODBC Driver enables you to access Salesforce.com data from an F# program.

posted on: 2018/06/06 15:30 | More

Tue, 05 June 2018

Connecting a 64-bit Application to Clarion TopSpeed

Use the Easysoft ODBC-ODBC Bridge to connect a 64-bit application to the 32-bit version of the TopSpeed ODBC driver.

posted on: 2018/05/06 14:00 | More

Fri, 01 June 2018

Testing the ODBC Layer

isql and ODBC Test are simple ODBC applications that enable you to prove your ODBC driver has been successfully been installed, licensed and configured.

posted on: 2018/01/06 15:15 | More

Thu, 31 May 2018

Inserting an Image from Oracle into SQL Server

How do I insert an image into a SQL Server table from Oracle Heterogeneous Services.

posted on: 2018/31/05 16:15 | More

Wed, 30 May 2018

How Does Your Oracle ODBC Driver Load the Oracle Client?

The Oracle ODBC driver can load the Oracle client software in a number of ways.

posted on: 2018/30/05 11:15 | More

Tue, 01 May 2018

Connecting AnySQL Maestro to Salesforce.com

The Salesforce.com ODBC Driver enables you to work with Salesforce.com data from within AnySQL Maestro.

posted on: 2018/01/05 13:00 | More

Thu, 26 April 2018

SQL Workbench/J

Use the Easysoft JDBC-ODBC Bridge to connect SQL Workbench/J to ODBC databases such as Microsoft Access.

posted on: 2018/26/04 13:00 | More

Wed, 25 April 2018

Using RStudio with a Non-System Version of the unixODBC Driver Manager

What to do if you want to use RStudio with a version of unixODBC that's not installed in the standard location for system libraries and include files. For example, a version of unixODBC included in your ODBC driver distribution.

posted on: 2018/25/04 15:15 | More

Mon, 23 April 2018

Connecting RStudio to SQL Server

Work with SQL Server data in your R programs.

posted on: 2018/23/04 15:00 | More

Thu, 19 April 2018

IntelliJ IDEA

Work with ODBC data in IntelliJ Idea by using Easysoft's JDBC-ODBC Bridge connector.

posted on: 2018/19/04 15:00 | More

Wed, 18 April 2018

I have upgraded the SQL Server ODBC Driver and performance has been negatively affected. What can I do?

How to restore previous behaviour for cursors if you notice peformace problems after upgrading.

posted on: 2018/18/04 11:00 | More

Tue, 17 April 2018

Setting Oracle Language Parameters for DG4ODBC

How to set HS_LANGUAGE and HS_NLS_NCHAR for your target database and ODBC driver.

posted on: 2018/17/04 11:15 | More

Mon, 16 April 2018

Using strace as a DG40DBC Debugging Tool

See what is happening "under the hood" by using strace to attach to the Oracle listener process.

posted on: 2018/16/04 12:00 | More

Thu, 12 April 2018

Connecting SQL Server to PostgreSQL

How to connect to PostgreSQL from a SQL Server linked server or SQL Server Integration Services.

posted on: 2018/12/04 11:45 | More

Mon, 26 March 2018

Using Microsoft Access Data in Wolfram Mathematica

Using JDBC to work with Access data in Wolfram Mathematica.

posted on: 2018/26/03 10:45 | More

Wed, 21 February 2018

Does Your ODBC Driver Support User Data Sources?

In response to one of our customers who asked the question: what determines whether you can use a User ODBC Data Source?

posted on: 2018/21/02 14:30 | More

Tue, 20 February 2018

Inserting SQL Server Data Into Salesforce with a Cursor

How to insert data into a Salesforce record by using a SQL Server cursor.

posted on: 2018/20/02 11:45 | More

Tue, 06 February 2018

ODBC Access from Windows Server Core

Installing, licensing and using Easysoft ODBC drivers on a GUI-less Windows Operating System.

posted on: 2018/06/02 12:45 | More

Mon, 05 February 2018

Command History in isql

If you build the unixODBC Driver Manager with readline support, you can use the arrow keys in isql to navigate through your SQL command history.

posted on: 2018/05/02 16:00 | More

Thu, 01 February 2018

Using isql with a Connection String

How to use DSN-less connections in isql.

posted on: 2018/01/02 15:00 | More

Wed, 31 January 2018

Using Data Protected with a Custom Key Store from Linux

To provide complete support for Microsoft's Always Encrypted feature, the SQL Server ODBC driver now supports custom key stores.

posted on: 2018/31/01 12:00 | More

Tue, 23 January 2018

Oracle Data Integrator (ODI)

Work with Excel data in Oracle Data Integrator (ODI) by using Easysoft's JDBC-ODBC Bridge connector.

posted on: 2018/23/01 16:45 | More

Fri, 19 January 2018

Inserting SQL Server data into Salesforce

The various ways in which you can populate Salesforce with SQL Server data.

posted on: 2018/18/01 15:00 | More

Fri, 12 January 2018

Using INSERT INTO from SQL Server To Change Salesforce Data

Inserting BLOB/CLOB data from a SQL Server table into Salesforce.

posted on: 2018/12/01 11:30 | More

Thu, 11 January 2018

Fine-Tuning Oracle DG40DBC

The DBMS_HS.ALTER_CLASS_CAPS procedure provides an additional way to configure DG4ODBC, if altering init<SID>.ora parameters does not resolve your issue.

posted on: 2018/11/01 15:15 | More

Wed, 10 January 2018

Data Access from Raspberry Pi

Accessing remote databases from Raspberry Pi.

posted on: 2018/10/01 15:00 | More

Mon, 18 December 2017

Updating Salesforce Data with a SQL Server Cursor

How to update a Salesforce record from SQL Server by using a cursor.

posted on: 2017/18/12 15:30 | More

Fri, 08 December 2017

Working with Java Data in Domo

Easysoft's ODBC-JDBC Gateway makes JDBC data sources available to Domo.

posted on: 2017/08/12 10:45 | More

Mon, 04 December 2017

Connecting PowerShell to Salesforce.com

The Salesforce.com ODBC Driver enables you to work with Salesforce.com data from a PowerShell script.

posted on: 2017/04/12 15:30 | More

Tue, 21 November 2017

Zoho Reports

Import ODBC data into Zoho Reports by using Easysoft's JDBC-ODBC Bridge connector.

posted on: 2017/21/11 14:45 | More

Fri, 19 October 2017

Analysing QuickBooks Data in Dundas BI

Dundas BI's generic ODBC interface enables you to work with QuickBooks data from a Dundas BI dashboard.

posted on: 2017/19/10 14:30 | More

Tue, 17 October 2017

Sisense

Easysoft's ODBC-JDBC Gateway enables you to use Sisense with data stored in a Java database.

posted on: 2017/17/10 16:00 | More

Thu, 12 October 2017

Dell Boomi

Work with ODBC data in Dell Boomi by using Easysoft's JDBC-ODBC Bridge connector.

posted on: 2017/12/10 16:15 | More

Fri, 15 September 2017

Working with Java Data in Qlik Sense

Qlik Sense includes a number of dedicated and generic data connectors. If you want to use Qlik Sense with data stored in a Java database, however, you will need a third party connector such as Easysoft's ODBC-JDBC Gateway.

posted on: 2017/09/15 12:00 | More

Tue, 12 September 2017

SQL Server 2017: Copying SQL Server Data from Linux to Windows with SSIS

Use Easysoft's SQL Server ODBC driver to copy data from a SQL Server instance on Linux to a SQL Server instance on Windows.

posted on: 2017/09/12 16:15 | More

Fri, 08 September 2017

SQL Server 2017: Importing CSV Data from Linux to Salesforce with SSIS

The new version of Microsoft's flagship database brings Linux support to SQL Server and SSIS.

posted on: 2017/09/08 16:00 | More

Thu, 31 August 2017

Working with Non-ASCII JDBC Data in Talend

A workaround if you are experiencing text corruption when using Talend to write non-ASCII data to a file.

posted on: 2017/08/31 12:45 | More

Tue, 29 August 2017

Connecting Talend on Windows to an ODBC Database

How to connect Talend to a data store for which an ODBC driver is available.

posted on: 2017/08/29 15:30 | More

Wed, 16 August 2017

Setting ODBC Connection Attributes Without Having To Write Code

Our SQL Server ODBC driver lets you set ODBC connection attributes in your ODBC data source. Normally, you do this by using the ODBC API, SQLSetConnectAttr.

posted on: 2017/08/16 16:00 | More

Tue, 15 August 2017

Salesforce TLS 1.0 Deprecation

Easysoft's Salesforce ODBC driver supports TLS 1.1+, the industry best practice encryption protocol required by Salesforce.

posted on: 2017/08/15 15:00 | More

Tue, 08 August 2017

Creating an ODBC Linked Server Without Configuring a Data Source

Using a dsnless connection to access an ODBC database from SQL Server.

posted on: 2017/08/08 13:00 | More

Mon, 07 August 2017

Connecting Delphi on Linux to SQL Server

Develop a SQL Server-based FireDAC application for Linux from RAD Studio on Windows.

posted on: 2017/08/07 14:30 | More

Wed, 26 July 2017

Connecting Delphi on Windows to Salesforce.com

The Salesforce.com ODBC Driver enables you to work with Salesforce.com data in Embarcadero Delphi applications.

posted on: 2017/07/26 14:20 | More

Tue, 12 July 2017

A workaround for: "Cursors are not supported on a table which has a clustered columnstore index"

What to do if you get this error.

posted on: 2017/07/12 15:30 | More

Wed, 14 June 2017

Connecting Visual COBOL to MySQL

How to access MySQL from Visual COBOL.

posted on: 2017/06/14 12:00 | More

Thu, 08 June 2017

Connecting Genero to SQL Server

Genero provides a database driver for use with Easysoft's SQL Server ODBC driver, and this enables you to create Genero programs that use SQL Server as their backend.

posted on: 2017/06/08 15:00 | More

Mon, 05 June 2017

Searching Microsoft Access Data with Elasticsearch

Using JDBC to import Access data into Elasticsearch.

posted on: 2017/06/05 16:00 | More

Tue, 30 May 2017

Connecting SQuirreL SQL to Microsoft Excel

Working with Microsoft Excel data in SQuirreL SQL.

posted on: 2017/05/30 12:00 | More

Tue, 23 May 2017

Using Oracle Heterogeneous Services with Two ODBC Data Sources

What to do if you want to connect Oracle to more than one DSN.

posted on: 2017/05/23 11:15 | More

Mon, 08 May 2017

UniVerse Tips

Some things to try if you cannot get UniVerse to use a system / driver supplied ODBC Driver Manager.

posted on: 2017/05/08 16:15 | More

Thu, 04 May 2017

When It's Urgent

What to do when you have an urgent issue for Easysoft support to assist you with.

posted on: 2017/05/04 11:00 | More

Fri, 28 April 2017

Working with MySQL TIMESTAMP Columns in SQL Server

Using CAST to workaround data integration issues.

posted on: 2017/04/28 18:00 | More

Thu, 13 April 2017

Troubleshooting Table Not Found Errors

If your ODBC driver reports that it cannot find a particular table, are you sure you're connecting to the correct database?

posted on: 2017/04/13 15:30 | More

Wed, 12 April 2017

Using SQL Server Integration Services (SSIS) to Populate QuickBooks Records

Insert records from a CSV file into QuickBooks.

posted on: 2017/04/12 16:15 | More

Fri, 07 April 2017

Updating Salesforce from Oracle

The Salesforce ODBC Driver enables you to work with Salesforce data in your Oracle applications.

posted on: 2017/04/07 12:00 | More

Thu, 06 April 2017

Quickbooks ODBC Driver

Read, write, and update QuickBooks data through ODBC.

posted on: 2017/04/06 15:00 | More

Tue, 29 November 2016

Connecting ODBC Applications to MySQL

How to connect to MySQL from ODBC applications such as Microsoft Access, Excel, SQL Server and Oracle.

posted on: 2016/11/29 15:00 | More

Mon, 21 November 2016

Inserting large object data into Salesforce.com from SQL Server

Inserting CLOB/BLOB data into Salesforce.com from SQL Server can be problematic. Here's a method we've found to be successful.

posted on: 2016/11/21 12:00 | More

Tue, 15 November 2016

Alpha Anywhere

The Salesforce.com ODBC Driver enables you connect to Salesforce.com from Alpha Anywhere.

posted on: 2016/11/15 11:00 | More

Fri, 11 November 2016

ODBC 4.0

A new release of ODBC for modern data stores.

posted on: 2016/11/11 10:30 | More

Mon, 07 November 2016

Inserting SQL Server Data with Oracle SQL*Loader

Using Easysoft's bcp tool with SQL*Loader provides an alternative to Oracle Heterogeneous Services (DG4ODBC) for integrating SQL Server data with Oracle.

posted on: 2016/11/07 13:00 | More

Tue, 01 November 2016

SQL Server Stored Procedures from Oracle

How do I call a stored procedure in SQL Server from Oracle Heterogeneous Services?

posted on: 2016/11/01 15:00 | More

Tue, 09 August 2016

Connecting RazorSQL to Salesforce.com

The Salesforce.com ODBC Driver enables you to work with Salesforce.com data in RazorSQL.

posted on: 2016/08/09 10:00 | More

Fri, 05 August 2016

Working with ODBC Data in DbVisualizer

Analyse ODBC data in DbVisualizer.

posted on: 2016/08/05 14:00 | More

Wed, 03 August 2016

Working with ODBC Data in DBeaver

Connect this free, multi-platform database tool to an ODBC data source.

posted on: 2016/08/03 15:30 | More

Mon, 01 August 2016

KNIME

Using data from an ODBC compliant database in KNIME.

posted on: 2016/08/01 14:00 | More

Thu, 28 July 2016

Aqua Data Studio

Using a generic data connector with Aqua Data Studio.

posted on: 2016/07/28 15:30 | More

Tue, 12 July 2016

Connecting SAS JMP to Salesforce.com

The Salesforce.com ODBC Driver enables you to extract Salesforce.com data for analysis in SAS JMP.

posted on: 2016/07/12 16:30 | More

Thu, 30 June 2016

Using ODBC Data in RapidMiner

How do you ensure that RapidMiner has a method of working with ODBC data?

posted on: 2016/06/30 15:00 | More

Wed, 08 June 2016

General error: OS Version mismatch

What to do if you get this error when using an Easysoft product.

posted on: 2016/06/08 15:30 | More

Tue, 07 June 2016

Working with Salesforce.com Data in SQL Server Reporting Services

The Salesforce.com ODBC Driver enables you to create a Reporting Services project based around Salesforce.com data.

posted on: 2016/06/17 12:30 | More

Wed, 11 May 2016

Retrieving Complete Error Messages in isql

By default, the ODBC test utility isql displays a generic error message if the connection fails, which does not identify the underlying reason for the failure.

posted on: 2016/05/11 14:30 | More

Tue, 10 May 2016

SAP Lumira and the JDBC-ODBC Bridge

The SAP Lumira distribution includes a generic connector that enables data sets to be constructed from any database for which an ODBC driver is available. There are some issues associated with the connector however.

posted on: 2016/05/10 16:00 | More

Thu, 05 May 2016

Connecting SAP Lumira to Microsoft Access

Using Microsoft Access data in a SAP Lumira dataset.

posted on: 2016/05/05 16:30 | More

Fri, 29 April 2016

Working with Java Data in Alteryx

Alteryx includes a number of dedicated and generic data connectors. If you want to use Alteryx with data stored in a Java database, however, you will need a third party connector such as Easysoft's ODBC-JDBC Gateway.

posted on: 2016/04/29 12:30 | More

Fri, 15 April 2016

Trapping Linked Server Errors

Working with a Salesforce.com linked server in the context of a TRY CATCH block in SQL Server.

posted on: 2016/04/15 11:30 | More

Mon, 04 April 2016

Salesforce.com Linked Servers and sp_columns_ex

Can I get information such as column names, data types and size from my Salesforce.com linked server?

posted on: 2016/04/04 16:00 | More

Wed, 16 March 2016

Easysoft Release ODBC ODBC Bridge for Windows 10

Solve "architecture mismatch" problems on the latest Windows platforms.

posted on: 2016/03/16 11:00 | More

SQL Server on Linux

Microsoft to release a Linux version of SQL Server in mid-2017. A preview version is available now.

posted on: 2016/03/14 10:30 | More

Mon, 29 February 2016

Analysing ODBC Data in IBM SPSS

IBM SPSS is an analytics package that can take data from multiple sources and use it to generate reports, charts and plots of distributions and trends. One of the ways of getting data into SPSS is from a database, and primarily, SPSS relies on ODBC to do this.

posted on: 2016/02/29 15:00 | More

Wed, 24 February 2016

Translating Salesforce Data Into EDI Format

How to exchange Salesforce.com data with an Electronic Data Interchange (EDI) application.

posted on: 2016/02/24 16:30 | More

Fri, 12 February 2016

Working Around Architecture Mismatch Errors When Using Microsoft Access

Your application's attempt to use an Access database backend fails with an "Architecture Mismatch" error. What can you do?

posted on: 2016/02/12 15:00 | More

Fri, 12 February 2016

Adding More Data Stores to Microsoft Power BI

Microsoft Power BI includes a number of connectors that enable you to analyse data in various popular data stores. This article shows you how you can integrate Power BI with data stores in backends for which there is no dedicated connector.

posted on: 2016/02/12 15:00 | More

Tue, 02 February 2016

MariaDB & External Data

MariaDB is a MySQL fork, which was initially derived from the 5.1 release of MySQL. Unlike MySQL, MariaDB can use external data as though the data was stored in a standard MariaDB table.

posted on: 2016/02/06 16:30 | More

Wed, 06 January 2016

Connecting Ignition to Microsoft Access

Using external data in a SCADA application.

posted on: 2016/01/06 16:10 | More

Wed, 25 November 2015

Using Easysoft ODBC Drivers with Informatica PowerCenter

How do you use an ODBC driver that is not included in the Informatica distribution with this popular ETL application...

posted on: 2015/11/25 11:30 | More

Wed, 04 November 2015

SQL Server 2016

The Community Technical Preview (CTP) release of SQL Server 2016, has given us the opportunity to try out some of the new features that will be available in the forthcoming version of the database...

posted on: 2015/11/04 11:01 | More

Thu, 01 July 2015

Visualising Data

Visualising data is the future. It is a couple of buzz words that are trending because now everyone needs to see their data in a new simpler way. Traditionally, huge data sets in column after column can be open to misinterpretation and the chance of just being swamped by numbers is always there...

posted on: 2015/07/01 15:14 | More

Thu, 21 May 2015

Introducing the Easysoft Oracle Driver into your SOA Environment

How do you introduce Oracle ODBC drivers into new organisations? Easysoft are here to help those companies who either have made or will make a decision to adopt the Easysoft Oracle ODBC driver as a solution for their connectivity problems...

posted on: 2015/05/21 15:57 | More

Fri, 24 Apr 2015

InterBase & Firebird Driver Updates

Updating operating system software and drivers is a daily part of life for most of us. And database driver updates are equally important. However they sometimes get consigned to the tomorrow list and just get left behind...

posted on: 2015/04/24 17:26 | More

Wed, 01 Oct 2014

Are you Shell Shocked?

We are all becoming increasingly aware of this new "deadly serious" bug that is potentially affecting millions of servers, computers and devices across the globe, but there is no risk to ODBC Drivers...

posted on: 2014/10/01 15:26 | More

SQL Access to MongoDB

MongoDB has grown quickly to become one of the most popular enterprise databases on the market today, and Easysoft Limited is using its data access expertise to provide these enterprises with SQL access to their "Big Data" solution...

posted on: 2014/10/01 15:26 | More

Mon, 01 Sep 2014

Always Listening

At Easysoft Limited we love talking to businesses and learning more about what drives them and any data issues that they have; at a recent data event in the UK I had the opportunity to do just that...

posted on: 2014/09/01 15:50 | More

Oracle ODBC Driver

With Oracle you have one of the most reliable databases on the market, and with Easysoft you have the most reliable Oracle ODBC Driver...

posted on: 2014/09/01 15:40 | More

Fri, 22 Aug 2014

Stop Data Hopping

If you're in sales or marketing then it's highly likely that like me you have a Data Hopping addiction...

posted on: 2014/08/22 09:53 | More

Thu, 21 Aug 2014

Disaster Recovery

We live in a world of immediate solutions and instant gratification, and we hate it when things stop dead in their tracks or don't work as expected...

posted on: 2014/08/21 17:03 | More

Dashboards & Data Access

Both standalone and web-based dashboards provide enterprises with the ability to display their corporate data in real-time from databases, data warehouses, repositories and other data sources in a single location...

posted on: 2014/08/21 16:58 | More

Mon, 18 Aug 2014

Business Intelligence Through ODBC

Great data provides great opportunities, and having access to your data is becoming a key business imperative for business intelligence...

posted on: 2014/08/18 15:43 | More

Wed, 13 Aug 2014

Easysoft ODBC Solutions

We are a data access business, and we have been providing and supporting data access solutions for over 20 years, there is absolutely nothing we don't know about ODBC and JDBC access...

posted on: 2014/08/13 14:20 | More

Tue, 12 Aug 2014

Microsoft Access is Still Relevant

With all the new database technologies becoming increasing available and adopted by organisations and IT departments, it's often easy to overlook MS Access as a valid database...

posted on: 2014/08/12 16:12 | More

Mon, 14 Jul 2014

Oracle is Market Leader

In a recent survey by Gartner, Oracle came out as the market leading database (by revenue) for the first time ever with almost 44% market share...

posted on: 2014/07/14 10:27 | More

Data: The Key to Competitive Gains

IT infrastructure, competitive differentiation and innovation are critical for businesses to succeed around the world in the digital age...

posted on: 2014/07/14 10:24 | More

Tue, 03 Jun 2014

OLE DB vs ODBC

Much had been written about OLE DB (Object Linking and Embedding, Database) since Microsoft released it in the late 1990s; it was designed to be a replacement and successor to ODBC...

posted on: 2014/06/03 12:29 | More

Fri, 09 May 2014

ODBC has the X Factor

ODBC has been with us for over 20 years now, and it's become a staple of the IT industry. As a 'technology' it has many advantages and no disadvantages...

posted on: 2014/05/09 16:48 | More

Thu, 08 May 2014

Easysoft Not Affected by Heartbleed

The Heartbleed Bug was announced last month and can only occur in open-source software called OpenSSL, which is widely used to encrypt different types of web communications...

posted on: 2014/05/08 09:50 | More

Thu, 01 May 2014

Data Warehousing

The Data Warehouse Institute promotes data warehousing as a foundation for a successful Business Intelligence (BI) program, but Data Warehouses are much more than a concept, they can seriously help businesses become more profitable...

posted on: 2014/05/01 08:58 | More

Tue, 15 Apr 2014

SQL Server 2014 ODBC Driver

Microsoft SQL Server 2014 provides users with more mission-critical capabilities and manageability for mission critical applications. SQL Server 2014 also provides new elements of data functionality that you might want to take advantage of...

posted on: 2014/04/15 10:33 | More

Mon, 14 Apr 2014

Java 8 ODBC support

The Oracle release of Java 8 was a huge one for the popular software vendor; the upgrade provides a fundamental change to the Java programming model and has resulted in the evolution of the JVM, Java language, a new Date-Time API and libraries...

posted on: 2014/04/14 17:06 | More

Free Trials and Free Support

Managing a business can be difficult enough at the best of times, so the processes that help your organisation understand what's happening within that business should be as simple as possible...

posted on: 2014/04/14 15:17 | More

Mon, 31 Mar 2014

Should You Care About Big Data?

If you are serious about selling more, and selling more profitably then the answer should be 'Yes'...

posted on: 2014/03/31 15:07 | More

Fri, 28 Mar 2014

Consider Drivers for your Back Up, Disaster Recovery and Development Machines

Don't get caught out...

posted on: 2014/03/28 11:56 | More

Tue, 25 Mar 2014

The Easysoft Software Development Kit (SDK)

It's been a few months now since we formally launched the Easysoft SDK—a custom driver development kit that allows access data solutions to be created quickly and easily by customers on a variety of different platforms, and it's been encouraging to see how well the package has been used by IT professionals to create their own ODBC Drivers...

posted on: 2014/03/25 15:45 | More

Connection Pooling

Database connections can often be 'expensive' to create for a number of reasons:..

posted on: 2014/03/25 15:39 | More

Wed, 12 Mar 2014

SQL Server 1.6 ODBC Driver

Today, Easysoft Limited released version 1.6 which supports SQL Server 2014 CTP2...

posted on: 2014/03/12 12:19 | More

Top Reasons why American IT Buyers Love To Buy ODBC and JDBC Drivers from Us

Our American clients tend to be more direct than others around the globe, they want to know that the software they need works, and will work first time, and will work every time. We are always happy to name numerous US businesses that have bought and run our Drivers (Disney, Apple, HP, Home Depot, the Bank of America and numerous government departments to name just a few)...

posted on: 2014/03/12 12:10 | More

Thu, 21 Nov 2013

Need Access to a Database From UniVerse/Unidata?

UniVerse enables you to build incredibly powerful business applications backed up by the embedded Universe data server and is used by leading organisations all over the world. We often find in talking to clients that connectivity is required to other ODBC databases within their business and they prefer the high performance real time access offered by Easysoft ODBC Drivers...

posted on: 2013/11/21 17:02 | More

Big Data - A Load of Old Nonsense?

Certainly without bringing it all together to analyse it then the data you hold within your business IS probably nonsense...

posted on: 2013/11/21 17:01 | More

Data Management

No one likes untidy data, and data can often be not where it's actually needed!..

posted on: 2013/11/21 16:24 | More

Derby ODBC Driver

The Easysoft Derby Driver for the popular Apache database is the perfect way to access the data you need from both the Linux and Unix platforms...

posted on: 2013/11/21 16:23 | More

Thu, 08 Aug 2013

Maximising your Investment in Salesforce.com

If you have Salesforce.com then we can make two simple assumptions about your business:..

posted on: 2013/08/08 12:26 | More

Fri, 26 Jul 2013

Training the Easysoft way!

Equipping customers to get the most from our products...

posted on: 2013/07/26 15:16 | More

SQL Server ODBC Driver Competitor Comparison

Easysoft recently ran some tests on its SQL Server ODBC Driver to see how it compared against its two nearest rivals...

posted on: 2013/07/26 15:12 | More

Fri, 12 Jul 2013

The Easysoft Apache Derby ODBC Driver successfully launched

We are happy to announce that our Apache Derby ODBC Driver for Linux and UNIX platforms has just been launched...

posted on: 2013/07/12 15:15 | More

Thu, 04 Jul 2013

Easysoft Limited release their Salesforce.com ODBC Driver

We have always listened to our customers, and when we started to receive feedback from the ones that used Salesforce.com, feedback that suggested that they needed additional data access solutions to help them get data that they need from the cloud then we set about developing a Salesforce.com ODBC Driver...

posted on: 2013/07/04 10:13 | More

Thu, 13 Jun 2013

Data Consultancy

Data is the lifeblood of any business; you know that you need accurate data to enable management to make the important decisions; you need up to the minute access to all your customer data so that you know that you are servicing them correctly and making the most of your sales opportunities with them...

posted on: 2013/06/13 10:17 | More

Tue, 28 May 2013

The Obligatory 'New Website' Blog Post

After literally months of planning, designing, developing and testing we have finally gone live with our new website...

posted on: 2013/05/28 13:52 | More

Is Free Really Worth It?

We love competitive markets, and we love the competitive market in which we operate, customers and prospects have a wide range of options that they can choose from, options to suit their budget, but sometimes their choice on the face of it isn't the right one to take...

posted on: 2013/05/28 13:12 | More

Easysoft OEM Partner Program

The Easysoft OEM Partner Program puts our products and technical expertise in the hands of application developers, middleware solutions providers and OEMs; it allows you to create additional value in your commercial products by bundling or embedding our driver solutions right into them...

posted on: 2013/05/28 13:12 | More

So What Is Big Data?

Data is an incredibly valuable business asset, but even more so when all the data you have on a particular topic is crunched (data analytics) into meaningful insight and actions that will then allow a brand to typically understand its internal workings, its market and customers in much more detail...

posted on: 2013/05/28 13:12 | More

What's In A Brand?

Easysoft has been in business servicing its customers for 20 years now and it's been a fabulous two decades full of ups and downs, and plenty of changes...

posted on: 2013/05/28 13:12 | More

Easysoft Celebrates Its 20th Anniversary

Easysoft Limited was established in 1993 and has become one of the most successful middleware companies of its type...

posted on: 2013/05/28 13:12 | More

Never Compromise

Easysoft has been delivering software solutions for 20 years now, and one of the many rules that we stick by is that we never compromise...

posted on: 2013/05/28 13:12 | More