Easysoft blog

Posts

Are you evaluating

an ODBC driver?

Yes I am!
Encrypting the connection between the Easysoft ODBC-ODBC Bridge client and server July 25, 2025

Configuring the ODBC-ODBC Bridge server on Windows to use TLS encryption with a self-generated certificate.

Fixing Microsoft Office 64-bit ODBC system DSN issues. July 24, 2025

Why has my ODBC DSN disappeared?

Transferring large datasets between Oracle and SQL Server July 23, 2025

Various methods for transferring large datasets between Oracle and SQL Server.

Connecting SAS to SQL Server or Azure SQL May 02, 2025

Use the Easysoft SQL Server ODBC driver with the SAS/ACCESS Interface to ODBC to work with SQL Server or Azure SQL data in SAS.

Querying, updating, and deleting data with the Easysoft Zoho Books ODBC driver October 07, 2024

Use Excel, Access, and any other application that supports ODBC to work with Zoho Books data.

Connecting to 4D from Java April 05, 2024

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

Oracle supported versions matrix April 05, 2024

Find out which Oracle version your Easysoft Oracle ODBC driver supports.

Inserting, updating, and deleting data with the Easysoft Xero ODBC driver March 08, 2024

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

Connecting Microsoft Excel to Xero September 28, 2023

Work with Xero data in your Excel spreadsheets.

SQL Server database ledger tables from Linux and UNIX February 06, 2023

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.

SQL Server supported versions matrix February 06, 2023

Find out which SQL Server version your Easysoft SQL Server ODBC driver supports.

Easysoft celebrates its 30th anniversary January 18, 2023

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

Cassandra ODBC driver November 24, 2022

Access Cassandra data from applications that support ODBC. For example, Perl, PHP, and Oracle.

Quickbooks Online ODBC driver November 08, 2022

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

Apache Spark ODBC driver June 17, 2022

Work with Apache Spark data in your ODBC applications.

Connect PyCharm to SQL Server January 31, 2022

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

Use Oracle Heterogeneous Services to work with SQL Server data in your Oracle 21c applications. November 26, 2021

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

Connecting .NET on Linux to an ODBC data source November 26, 2021

Use .NET with an Easysoft ODBC driver on Linux.

Using ODBC with Salesforce and Okta Single Sign On (SSO) October 13, 2021

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

Using ODBC with Salesforce and OneLogin Single Sign On (SSO) October 06, 2021

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

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

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

Using ODBC with Salesforce and Azure Active Directory (AD) Single Sign On (SSO) September 08, 2021

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

PayPal ODBC driver July 05, 2021

ODBC connector for PayPal.

ShipWorks June 23, 2021

How to use ShipWorks with an Easysoft ODBC driver.

Google BigQuery ODBC driver June 21, 2021

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

Zoho CRM ODBC driver June 10, 2021

The Zoho CRM ODBC driver allows you to use Zoho CRM data in any application that supports ODBC

Connecting Oracle to PostgreSQL March 19, 2021

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

Connect SQL Server to SugarCRM April 13, 2021

Work with SugarCRM data in SQL Server.

SugarCRM ODBC driver April 13, 2021

Read, write, and update SugarCRM data through ODBC.

TDS Server: Use Transact-SQL (T-SQL) statements to work with Salesforce data in SQL Server July 12, 2020

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

SQL Server: Always Encrypted April 11, 2020

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

Accessing data protected with an Azure Key Vault from Linux March 11, 2020

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

SQL Server BULK INSERT from Linux October 27, 2020

Initiate a SQL Server BULK INSERT from Linux.

Connect to QuickBooks Online from Strawberry Perl December 10, 2020

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

Connect to QuickBooks Online from Microsoft Office August 10, 2020

Work with QuickBooks Online data from your Microsoft Office applications.

Connecting a 32-bit application to jBASE July 31, 2020

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.

Pegasystems Pega Robot Studio July 17, 2020

Work with SQL Server data in Pegasystems Pega Robot Studio.

ReadyCloud ReadyShipper X July 16, 2020

Importing and exporting ReadyCloud ReadyShipper X orders by using ODBC.

Copy data from Salesforce to SQL Server with Spectral Core July 10, 2020

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

Alibaba Cloud July 09, 2020

Database products in the Alibaba Cloud.

Huawei GaussDB July 03, 2020

Client application connectivity options for Huawei GaussDB.

Connecting SQL Server to a Java database June 11, 2020

Use a linked server with a JDBC driver connection.

Using SolarWinds Serv-U on Linux with a SQL Server authentication database June 09, 2020

Authenticate Serv-U users by using a SQL Server back end.

ServiceNow June 05, 2020

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

Board June 03, 2020

How to use Board with a third-party ODBC driver.

Using MySQL with Oracle Heterogeneous Services May 29, 2020

Use Oracle Heterogeneous Services to transparently integrate Oracle with MySQL.

Connect to QuickBooks Online from Oracle May 15, 2020

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

Connect APPX to SQL Server May 15, 2020

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

Connect SAP IQ to SQL Server May 14, 2020

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

SQL access to MongoDB in the cloud April 24, 2020

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

Connect to QuickBooks Online from SQL Server April 20, 2020

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

Tips for using SQL Server with Salesforce April 06, 2020

Guidance on using SQL Server with Salesforce.

Apache Nifi November 21, 2019

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

Connecting Oracle to SQL Server from Windows November 01, 2019

Connect Oracle applications on Windows to SQL Server.

Enlisting SQL Server in a distributed XA transaction October 31, 2019

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

Transforming ODBC data in CloverDX July 30, 2019

Work with ODBC data in CloverDX.

Connecting a 64-bit application to Acomba February 07, 2019

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

A workaround for the Access 255 columns limit June 13, 2019

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

Link to Salesforce data from Microsoft Access June 11, 2019

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

Easysoft ODBC drivers and the ODBCINST library January 04, 2019

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

Connecting to Lotus Notes from Java March 27, 2019

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

Salesforce API query cursor limits March 25, 2019

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

Using OAuth to authenticate your ODBC connection to Salesforce March 22, 2019

The Salesforce ODBC driver now supports OAuth.

The LD_DEBUG environment variable March 19, 2019

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

Connecting PolyBase to Salesforce March 08, 2019

Integrate your Salesforce data with SQL Server by using PolyBase.

Connecting Linux and UNIX to Azure SQL Data Warehouse February 26, 2019

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

Changing how isql executes SQL February 21, 2019

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

Using pseudo columns with a linked server February 14, 2019

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

Connecting SQL Server to Oracle February 11, 2019

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

Does your Salesforce driver support bulk actions? February 06, 2019

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

SQL Server bcp utility and the numeric data type February 04, 2019

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

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

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

Connecting to Sage from Java January 07, 2019

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

Connecting Oracle to SQL Server over a secure connection January 07, 2019

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

Using Salesforce SOQL from Linux January 04, 2019

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

Connecting applications running on Linux to Amazon Relational Database Services (RDS) for SQL Server January 03, 2019

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

SQL Server: "Communication link failure Required SSL (failed to receive packet)" October 12, 2018

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

Connecting Oracle to Amazon Aurora July 12, 2018

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

Connecting PHP on Linux to Microsoft Access on a Windows share November 29, 2018

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

Accessing a file DSN from Java November 26, 2018

How to connect to a file data source from Java by using the JDBC-ODBC Bridge.

Salesforce SOQL from Windows PowerShell October 18, 2018

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

A workaround for the "Cursor support is not an implemented feature for SQL Server Parallel DataWarehousing TDS" error October 17, 2018

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.

Attaching a ContentDocument to a Salesforce custom object October 15, 2018

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

Investigating an "ORA 28513" DG4ODBC error October 15, 2018

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

Investigating an "ORA 02063" DG4ODBC error September 28, 2018

"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.

Salesforce SOQL from Java September 06, 2018

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

Tips for using SQL Server with Salesforce SOQL August 14, 2018

Guidance on using SQL Server with Salesforce SOQL.

Bulk Salesforce inserts from Microsoft Access August 14, 2018

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

Salesforce SOQL from SQL Server July 25, 2018

Use Salesforce SOQL from SQL Server.

Salesforce SOQL from SAP Crystal Reports July 24, 2018

Use Salesforce SOQL from Crystal Reports.

Salesforce SOQL from Oracle July 19, 2018

Use Salesforce SOQL from your Oracle applications.

Salesforce SOQL from Apache OpenOffice July 17, 2018

Use Salesforce SOQL from your Apache OpenOffice applications.

Salesforce SOQL from Microsoft Office July 16, 2018

Use Salesforce SOQL from your Microsoft Office applications.

SQL Azure: "Database 'XXXYYY' on server '' is not currently available" July 11, 2018

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

Getting an ODBC trace log from a linked server June 18, 2018

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.

Eclipse Data Tools Platform June 15, 2018

Use the Easysoft JDBC-ODBC Bridge to connect Eclipse Data Tools Platform to ODBC data sources.

Connecting FlySpeed SQL Query to Salesforce June 07, 2018

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

Connecting F# to Salesforce June 06, 2018

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

Connecting a 64-bit application to Clarion TopSpeed June 05, 2018

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

Testing the ODBC layer June 01, 2018

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

Inserting an image from Oracle into SQL Server May 31, 2018

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

How does your Oracle ODBC driver load the Oracle client? May 30, 2018

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

Connecting AnySQL Maestro to Salesforce May 01, 2018

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

SQL Workbench/J April 26, 2018

Use the Easysoft JDBC-ODBC Bridge to connect SQL Workbench/J to ODBC data sources.

Using RStudio with a non-system version of the unixODBC Driver Manager April 25, 2018

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.

Connecting RStudio to SQL Server April 23, 2018

Work with SQL Server data in your R programs.

IntelliJ IDEA April 19, 2018

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

I have upgraded the SQL Server ODBC driver and performance has been negatively affected. What can I do? April 18, 2018

How to restore previous behaviour for cursors if you have performance problems after upgrading.

Setting Oracle language parameters for DG4ODBC April 17, 2018

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

Using strace as a DG40DBC debugging tool April 16, 2018

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

Connecting SQL Server to PostgreSQL April 12, 2018

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

Using Microsoft Access data in Wolfram Mathematica March 26, 2018

Use JDBC to work with Access data in Wolfram Mathematica.

Does your ODBC driver support user data sources? February 21, 2018

In response to one of our customers who asked the question: what determines whether you can use a user ODBC data source?

Inserting SQL Server data into Salesforce with a cursor February 20, 2018

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

ODBC access from Windows Server Core February 06, 2018

Installing, licensing, and using Easysoft ODBC drivers on a GUI-less Windows operating system.

Command history in isql February 05, 2018

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.

Using isql with a connection string February 01, 2018

How to use DSN-less connections in isql.

Using data protected with a custom key store from Linux January 31, 2018

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

Oracle Data Integrator (ODI) January 23, 2018

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

Inserting SQL Server data into Salesforce January 18, 2018

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

Using INSERT INTO from SQL Server to change Salesforce data January 12, 2018

Insert BLOB or CLOB data from a SQL Server table into Salesforce.

Fine-tuning Oracle DG40DBC January 11, 2018

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

Data access from Raspberry Pi January 10, 2018

Access remote databases from Raspberry Pi.

Updating Salesforce data with a SQL Server cursor December 18, 2017

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

Working with Java data in Domo December 08, 2017

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

Connecting PowerShell to Salesforce December 04, 2017

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

Zoho Reports November 21, 2017

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

Analysing QuickBooks data in Dundas BI October 19, 2017

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

Sisense October 17, 2017

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

Dell Boomi October 12, 2017

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

Working with Java data in Qlik Sense September 15, 2017

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.

Running an SSIS package on Linux September 12, 2017

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

SQL Server 2017: Importing CSV data from Linux to Salesforce with SSIS September 08, 2017

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

Working with non-ASCII JDBC data in Talend August 31, 2017

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

Connecting Talend on Windows to an ODBC data source August 29, 2017

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

Setting ODBC connection attributes without having to write code August 16, 2017

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.

Salesforce TLS 1.0 deprecation August 15, 2017

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

Creating an ODBC linked server without configuring a data source August 08, 2017

Use a DSN-less connection to access an ODBC database from SQL Server.

Connecting Delphi on Linux to SQL Server August 07, 2017

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

Connecting Delphi on Windows to Salesforce July 26, 2017

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

Connecting Visual COBOL to MySQL June 14, 2017

How to access MySQL from Visual COBOL.

Connecting Genero to SQL Server June 08, 2017

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

Searching Microsoft Access data with Elasticsearch June 05, 2017

Use JDBC to import Access data into Elasticsearch.

Connecting SQuirreL SQL to Microsoft Excel May 30, 2017

Work with Microsoft Excel data in SQuirreL SQL.

Using Oracle Heterogeneous Services with two ODBC data sources May 23, 2017

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

UniVerse tips May 08, 2017

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

When it's urgent May 04, 2017

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

Working with MySQL TIMESTAMP columns in SQL Server April 28, 2017

Use CAST to work around data integration issues.

Troubleshooting "table not found" errors April 13, 2017

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

Using SQL Server Integration Services (SSIS) to populate QuickBooks records April 12, 2017

Insert records from a CSV file into QuickBooks.

Updating Salesforce from Oracle April 07, 2017

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

QuickBooks ODBC driver April 06, 2017

Read, write, and update QuickBooks data through ODBC.

Connecting ODBC applications to MySQL November 29, 2016

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

Inserting large object data into Salesforce from SQL Server November 21, 2016

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

Alpha Anywhere November 15, 2016

The Salesforce ODBC driver enables you connect to Salesforce from Alpha Anywhere.

ODBC 4.0 November 11, 2016

A new release of ODBC for modern data stores.

Inserting SQL Server data with Oracle SQL*Loader November 07, 2016

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

Calling SQL Server stored procedures from Oracle November 01, 2016

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

Connecting RazorSQL to Salesforce September 08, 2016

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

Working with ODBC data in DbVisualizer August 05, 2016

Analyse ODBC data in DbVisualizer.

Working with ODBC data in DBeaver August 03, 2016

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

KNIME August 01, 2016

Use data from an ODBC compliant database in KNIME.

Aqua Data Studio July 28, 2016

Use a generic data connector with Aqua Data Studio.

Connecting SAS JMP to Salesforce July 12, 2016

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

Using ODBC data in RapidMiner June 30, 2016

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

General error: OS Version mismatch June 08, 2016

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

Working with Salesforce data in SQL Server Reporting Services June 17, 2016

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

Retrieving complete error messages in isql May 11, 2016

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.

SAP Lumira and the JDBC-ODBC Bridge May 10, 2016

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.

Connecting SAP Lumira to Microsoft Access May 05, 2016

Use Microsoft Access data in a SAP Lumira dataset.

Working with Java data in Alteryx April 29, 2016

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.

Trapping linked server errors April 15, 2016

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

Salesforce linked servers and sp_columns_ex April 04, 2016

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

Easysoft release ODBC-ODBC Bridge for Windows 10 March 16, 2016

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

SQL Server on Linux March 14, 2016

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

Analysing ODBC data in IBM SPSS February 29, 2016

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.

Translating Salesforce data into EDI format February 24, 2016

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

Working around "Architecture Mismatch" errors when using Microsoft Access February 12, 2016

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

Adding more data stores to Microsoft Power BI February 12, 2016

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 back ends for which there is no dedicated connector.

MariaDB and external data February 06, 2016

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.

Connecting Ignition to Microsoft Access January 06, 2016

Use external data in a SCADA application.

Using Easysoft ODBC drivers with Informatica PowerCenter November 25, 2015

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

SQL Server 2016 November 04, 2015

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.

Visualising data July 01, 2015

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.

InterBase and Firebird ODBC driver updates April 24, 2015

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.

Are you Shellshocked? October 01, 2014

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.

SQL access to MongoDB October 01, 2014

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

Always listening September 01, 2014

At Easysoft 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.

Oracle ODBC driver September 01, 2014

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

Stop data hopping August 22, 2014

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

Disaster recovery August 21, 2014

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.

Dashboards and data access August 21, 2014

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.

Business intelligence through ODBC August 18, 2014

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

Easysoft ODBC solutions August 13, 2014

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

Microsoft Access is still relevant August 12, 2014

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

Oracle is the market leader July 14, 2014

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.

Data: The key to competitive gains July 14, 2014

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

OLE DB versus ODBC June 03, 2014

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

ODBC has the X Factor May 09, 2014

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

Easysoft not affected by Heartbleed May 08, 2014

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.

Data warehousing May 01, 2014

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.

SQL Server 2014 ODBC driver April 15, 2014

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

Java 8 ODBC support April 14, 2014

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.

Free trials and free support April 14, 2014

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.

Should you care about big data? March 31, 2014

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

The Easysoft Software Development Kit (SDK) March 25, 2014

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 discover how well the package has been used by IT professionals to create their own ODBC drivers.

Connection pooling March 25, 2014

Database connections can often be "expensive" to create. Here's a potential solution.

SQL Server 1.6 ODBC driver March 12, 2014

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

Top reasons why American IT buyers love to buy ODBC and JDBC drivers from us March 12, 2014

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).

Need access to a database from UniVerse or UniData? November 21, 2013

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 databases within their business and they prefer the high-performance, real-time access offered by Easysoft ODBC drivers.

Big data — a load of old nonsense? November 21, 2013

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

Data management November 21, 2013

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

Derby ODBC driver November 21, 2013

The Easysoft Derby ODBC driver is the perfect way to access the Derby data you need from both Linux and UNIX platforms.

Maximising your investment in Salesforce August 08, 2013

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

Training the Easysoft way! July 26, 2013

Equipping customers to get the most from our products.

SQL Server ODBC driver competitor comparison July 26, 2013

Easysoft recently ran some tests on its SQL Server ODBC driver to find out how it compared against its two nearest rivals.

The Easysoft Apache Derby ODBC driver successfully launched July 12, 2013

We're happy to announce that our Apache Derby ODBC driver for Linux and UNIX platforms has just been launched.

Easysoft release the Salesforce ODBC driver July 04, 2013

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

Data consultancy June 13, 2013

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.

The obligatory "new web site" blog post May 28, 2013

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

Is free really worth it? May 28, 2013

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.

Easysoft OEM partner program May 28, 2013

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.

So, what is big data? May 28, 2013

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 understand its internal workings, its market, and customers in much more detail.

What's in a brand? May 28, 2013

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

Never compromise May 28, 2013

We've been delivering software solutions for over 30 years now, and one of the many rules that we stick by is that we never compromise.

Share: