Easysoft Blog

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

Mon, 14 August 2017

Apache Nifi

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

posted on: 2017/08/14 16: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

Mon, 24 July 2017

Connecting Oracle® to PostgreSQL

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

posted on: 2017/07/24 14:30 | 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

Fri, 19 August 2016

Transform ODBC Data in CloverETL

Working with ODBC Data in CloverETL.

posted on: 2016/08/19 16:15 | 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

Mon, 14 March 2016

SQL Server Supported Versions Matrix

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

posted on: 2016/03/14 15:30 | 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

Wed, 09 March 2016

SQL Server 2016: Always Encrypted

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

posted on: 2016/03/09 16: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

Tue, 29 Jul 2014

SQL Access to Salesforce.com

Are you trying to unlock the data in your Salesforce.com application for BI and reporting purposes...

posted on: 2014/07/29 10:13 | 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


Oracle is a registered trademark of Oracle Corporation and/or its affiliates.