Configuring the ODBC-ODBC Bridge server on Windows to use TLS encryption with a self-generated certificate.
Why has my ODBC DSN disappeared?
Various methods for transferring large datasets between Oracle and SQL Server.
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.
Use Excel, Access, and any other application that supports ODBC to work with Zoho Books data.
Work with your 4D data from Java by using JDBC-ODBC Bridge.
Find out which Oracle version your Easysoft Oracle ODBC driver supports.
Code samples, example SQL statements, and SQL Server linked server tips.
Work with Xero data in your Excel spreadsheets.
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.
Find out which SQL Server version your Easysoft SQL Server ODBC driver supports.
Easysoft was established in 1993 and has become one of the most successful middleware companies of its type.
Access Cassandra data from applications that support ODBC. For example, Perl, PHP, and Oracle.
Read, write, and update QuickBooks Online data through ODBC.
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 applications.
Use .NET with an Easysoft ODBC driver on Linux.
Use the Easysoft Salesforce ODBC driver with a Salesforce instance that has been integrated with Okta SSO.
Use the Easysoft Salesforce ODBC driver with a Salesforce instance that has been integrated with OneLogin SSO.
Use the Easysoft Salesforce ODBC driver with a Salesforce instance that has been integrated with Active Directory Federation Services (ADFS) SSO.
Use the Easysoft Salesforce ODBC driver with a Salesforce instance that has been integrated with Azure AD SSO.
Work with Google BigQuery data in some popular applications on Windows.
The Zoho CRM ODBC driver allows you to use Zoho CRM data in any application that supports ODBC
How to connect to PostgreSQL from Oracle by using Heterogeneous Services and DG4ODBC.
The optimal Easysoft solution for using T-SQL with Salesforce.
Keep SQL Server data protected with the Always Encrypted database security feature.
The SQL Server ODBC driver now supports Always Encrypted columns that have been secured with an Azure Key Vault.
Work with QuickBooks Online data from your Perl scripts and applications.
Work with QuickBooks Online data from your Microsoft Office applications.
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.
Work with SQL Server data in Pegasystems Pega Robot Studio.
Importing and exporting ReadyCloud ReadyShipper X orders by using ODBC.
Use the Easysoft Salesforce ODBC driver to work with Salesforce data in SQL Server.
Use a linked server with a JDBC driver connection.
Authenticate Serv-U users by using a SQL Server back end.
ServiceNow can be accessed from an ODBC application on Windows, but what if your ODBC application is running on Linux or UNIX?
Use Oracle Heterogeneous Services to transparently integrate Oracle with MySQL.
Use a database link to work with QuickBooks Online data in Oracle applications such as Toad, SQL Developer, and SQL*Plus.
APPX provides an ODBC interface that enables it to use non-APPX data such as information stored in SQL Server.
Use a remote server to work with SQL Server data by using ODBC.
Connect applications such as SQL Server, Office, and PHP to MongoDB Atlas.
Use a linked server to work with QuickBooks Online data, just as if you were working with data stored in a SQL Server table.
Guidance on using SQL Server with Salesforce.
Work with ODBC data in Apache Nifi by using Easysoft's JDBC-ODBC Bridge connector.
Connect Oracle applications on Windows to SQL Server.
How to access SQL Server in the context of an XA transaction with the Easysoft SQL Server ODBC driver and Oracle Tuxedo.
Use the Easysoft ODBC-ODBC Bridge to connect a 64-bit application to the 32-bit version of the Acomba ODBC driver.
Use a pass-through SQL query to choose which columns are retrieved from an ODBC data source.
Use the Salesforce ODBC driver to work with Salesforce data in Microsoft Access.
Easysoft ODBC drivers on Linux and UNIX are linked against the libodbcinst library.
Work with your Lotus Notes data from Java by using JDBC-ODBC Bridge.
A user can have up to 10 query cursors open at a time.
The Salesforce ODBC driver now supports OAuth.
LD_DEBUG
environment variable
March 19, 2019
LD_DEBUG
helps you find out why your Linux application is unable to load an ODBC library.
Integrate your Salesforce data with SQL Server by using PolyBase.
Access data stored in an Azure SQL Data Warehouse from your Linux or UNIX platform.
How to change the ODBC API that isql uses to execute SQL statements.
Use OPENQUERY
rather than four-part SQL if you want to use pseudo columns.
A workaround for this linked server error.
How to connect to an Oracle linked server from SQL Server.
When to use an Easysoft driver and when to use a tool that uses Salesforce's BULK API.
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.
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.
Work with your Sage data from Java by using JDBC-ODBC Bridge.
How to connect to SQL Server from Oracle over an encrypted network connection.
Use Salesforce SOQL from Linux applications such as Oracle, PHP, Python, Perl, and OpenOffice.
Work with SQL Server data stored in the Amazon Web Services (AWS) cloud from Linux.
A solution for Easysoft SQL Server ODBC driver users who get this error.
How to connect Oracle to a MySQL or PostgreSQL database running on Amazon Aurora.
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.
How to connect to a file data source from Java by using the JDBC-ODBC Bridge.
The Salesforce ODBC driver lets you use Salesforce SOQL from a PowerShell script.
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.
ContentDocument
to a Salesforce custom object
October 15, 2018
Using SQL to share a ContentDocument
with a custom object in Salesforce.
In this customer case, an Oracle environment variable was preventing Oracle DG4ODBC from loading our ODBC layer.
"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.
Work with your Salesforce data from Java by using Salesforce ODBC driver.
Guidance on using SQL Server with Salesforce SOQL.
Use the Salesforce ODBC driver to insert multiple Access records into Salesforce in one batch.
Use Salesforce SOQL from your Apache OpenOffice applications.
Use Salesforce SOQL from your Microsoft Office applications.
A solution for Easysoft SQL Azure ODBC driver users who get this error.
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.
Use the Easysoft JDBC-ODBC Bridge to connect Eclipse Data Tools Platform to ODBC data sources.
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.
The Salesforce ODBC driver enables you to access Salesforce data from an F# program.
Use the Easysoft ODBC-ODBC Bridge to connect a 64-bit application to the 32-bit version of the TopSpeed ODBC driver.
isql
and ODBC Test are simple ODBC applications that enable you to prove your ODBC driver has been successfully been installed, licensed, and configured.
How do I insert an image into a SQL Server table from Oracle Heterogeneous Services.
The Oracle ODBC driver can load the Oracle client software in a number of ways.
The Salesforce ODBC driver enables you to work with Salesforce data from within AnySQL Maestro.
Use the Easysoft JDBC-ODBC Bridge to connect SQL Workbench/J to ODBC data sources.
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.
Work with ODBC data in IntelliJ Idea by using Easysoft's JDBC-ODBC Bridge connector.
How to restore previous behaviour for cursors if you have performance problems after upgrading.
How to set HS_LANGUAGE
and HS_NLS_NCHAR
for your target database and ODBC driver.
Find out what is happening "under the hood" by using strace to attach to the Oracle listener process.
How to connect to PostgreSQL from a SQL Server linked server or SQL Server Integration Services.
Use JDBC to work with Access data in Wolfram Mathematica.
In response to one of our customers who asked the question: what determines whether you can use a user ODBC data source?
How to insert data into a Salesforce record by using a SQL Server cursor.
Installing, licensing, and using Easysoft ODBC drivers on a GUI-less Windows operating system.
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.
To provide complete support for Microsoft's Always Encrypted feature, the SQL Server ODBC driver now supports custom key stores.
Work with Excel data in Oracle Data Integrator (ODI) by using Easysoft's JDBC-ODBC Bridge connector.
The various ways in which you can populate Salesforce with SQL Server data.
INSERT INTO
from SQL Server to change Salesforce data
January 12, 2018
Insert BLOB
or CLOB
data from a SQL Server table into Salesforce.
The DBMS_HS.ALTER_CLASS_CAPS
procedure provides an additional way to configure DG4ODBC, if altering initSID.ora
parameters does not resolve your issue.
How to update a Salesforce record from SQL Server by using a cursor.
Easysoft's ODBC-JDBC Gateway makes JDBC data sources available to Domo.
The Salesforce ODBC driver enables you to work with Salesforce data from a PowerShell script.
Import ODBC data into Zoho Reports by using Easysoft's JDBC-ODBC Bridge connector.
Dundas BI's generic ODBC interface enables you to work with QuickBooks data from a Dundas BI dashboard.
Easysoft's ODBC-JDBC Gateway enables you to use Sisense with data stored in a Java database.
Work with ODBC data in Dell Boomi by using Easysoft's JDBC-ODBC Bridge connector.
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.
Use Easysoft's SQL Server ODBC driver to copy data from a SQL Server instance on Linux to a SQL Server instance on Windows.
The new version of Microsoft's flagship database brings Linux support to SQL Server and SSIS.
A workaround if you are experiencing text corruption when using Talend to write non-ASCII data to a file.
How to connect Talend to a data store for which an ODBC driver is available.
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
.
Easysoft's Salesforce ODBC driver supports TLS 1.1+, the industry best practice encryption protocol required by Salesforce.
Use a DSN-less connection to access an ODBC database from SQL Server.
Develop a SQL Server-based FireDAC application for Linux from RAD Studio on Windows.
The Salesforce ODBC driver enables you to work with Salesforce data in Embarcadero Delphi applications.
What to do if you get this error.
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.
Use JDBC to import Access data into Elasticsearch.
Work with Microsoft Excel data in SQuirreL SQL.
What to do if you want to connect Oracle to more than one DSN.
Some things to try if you cannot get UniVerse to use a system- or driver-supplied ODBC Driver Manager.
What to do when you have an urgent issue for Easysoft support to assist you with.
TIMESTAMP
columns in SQL Server
April 28, 2017
Use CAST
to work around data integration issues.
If your ODBC driver reports that it cannot find a particular table, are you sure you're connecting to the correct database?
Insert records from a CSV file into QuickBooks.
The Salesforce ODBC driver enables you to work with Salesforce data in your Oracle applications.
How to connect to MySQL from ODBC applications such as Microsoft Access, Excel, SQL Server, and Oracle.
Insert CLOB
and BLOB
data into Salesforce from SQL Server can be problematic. Here's a method we've found to be successful.
The Salesforce ODBC driver enables you connect to Salesforce from Alpha Anywhere.
Using Easysoft's bcp
tool with SQL*Loader
provides an alternative to Oracle Heterogeneous Services (DG4ODBC) for integrating SQL Server data with Oracle.
How do I call a stored procedure in SQL Server from Oracle Heterogeneous Services?
The Salesforce ODBC driver enables you to work with Salesforce data in RazorSQL.
Connect this free, multi-platform database tool to an ODBC data source.
The Salesforce ODBC driver enables you to extract Salesforce data for analysis in SAS JMP.
How do you ensure that RapidMiner has a method of working with ODBC data?
What to do if you get this error when using an Easysoft product.
The Salesforce ODBC driver enables you to create a Reporting Services project based around Salesforce data.
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.
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.
Use Microsoft Access data in a SAP Lumira dataset.
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.
Work with a Salesforce linked server in the context of a TRY CATCH
block in SQL Server.
sp_columns_ex
April 04, 2016
Can I get information such as column names, data types, and size from my Salesforce linked server?
Solve "architecture mismatch" problems on the latest Windows platforms.
Microsoft to release a Linux version of SQL Server in mid-2017. A preview version is available now.
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.
How to exchange Salesforce data with an Electronic Data Interchange (EDI) application.
Your application's attempt to use an Access database back end fails with an "Architecture Mismatch" error. What can you do?
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 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.
How do you use an ODBC driver that is not included in the Informatica distribution with this popular ETL application?
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 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.
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.
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.
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.
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.
With Oracle you have one of the most reliable databases on the market, and with Easysoft you have the most reliable Oracle ODBC driver.
If you're in sales or marketing then it's highly likely that like me you have a data hopping addiction.
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.
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.
Great data provides great opportunities, and having access to your data is becoming a key business imperative for business intelligence.
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.
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.
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.
IT infrastructure, competitive differentiation, and innovation are critical for businesses to succeed around the world in the digital age.
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 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.
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.
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.
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.
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.
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.
If you are serious about selling more, and selling more profitably then the answer should be "Yes."
Don't get caught out.
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.
Database connections can often be "expensive" to create. Here's a potential solution.
Today, Easysoft released version 1.6, which supports SQL Server 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).
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.
Certainly, without bringing it all together to analyse, the data you hold within your business is probably nonsense.
No one likes untidy data, and data can often be not where it's actually needed!
The Easysoft Derby ODBC driver is the perfect way to access the Derby data you need from both Linux and UNIX platforms.
If you have Salesforce then we can make two simple assumptions about your business...
Easysoft recently ran some tests on its SQL Server ODBC driver to find out how it compared against its two nearest rivals.
We're happy to announce that our Apache Derby ODBC driver for Linux and UNIX platforms has just been launched.
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 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.
After literally months of planning, designing, developing, and testing, we have finally gone live with our new web site.
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.
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.
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.
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.
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.