EXAjload is a standard tool for bulk data loading. Its documentation is brief, but the tool is more powerful than you might think.
View full article
This article explains some best practices on importing/exporting data with SQL Server
View full article
Operationalize huge amounts of data in OutSystems with our new Exasol  database connector for  OutSystems !
View full article
This article adresses some common topics when migrating from SQL Server to Exasol.
View full article
You have an EXASOL database and want to read data from Microsoft Azure Blob Storage, such as: You want to import all files in a specific folder into a specific table. So you need to generate URLs for all the files in that folder. You want to use authentication, but you don't want to create the required URL signature manually.
View full article
This article describes a solution to users not being able to login via LDAP
View full article
This article explains some of the fail safety mechanisms that clients can perform. 
View full article
Problem After openJDK was successfully installed EXAplus still won't start with an error message like Can not find the Java Runtime Environment needed by EXAplus. Trying to use system wide virtual machine (from registry) instead. No 64 bit java virtual machine found in registry. Diagnosis EXAplus requires a java runtime instance and proper registry entries to start Solution 1. Verify openJDK installation Execute command "java -version" on the command line A possible output may look like openjdk 11.0.2 2019-01-15 OpenJDK Runtime Environment 18.9 (build 11.0.2+9) OpenJDK 64-Bit Server VM 18.9 (build 11.0.2+9, mixed mode) The next step depends on what you downloaded, a JRE only or the complete JDK. 2. a) JDK It comes with a MSI installer and works as any other windows installer and does the necessary registry entries. But EXAplus needs a JRE instance to start. Contrary to Oracles installation, there's no own "jre" folder in the installation path of the JDK. Just create one and copy all contents again to this folder and EXAplus should start. 2.b) JRE The JRE is only a ZIP file and doesn't edit registry during the unzip to the desired folder. You can edit the registry using the Registry Editor. This article describes some tips on doing this, or you can view Microsoft's documentation. - edit existing registry entries manually - create the proper registry entries The path is {{HKEY_LOCAL_MACHINE\Software\JavaSoft}} Another workaround Start Exaplus direct with a java command. For further executions create an icon for the call. Example: "c:\Program Files\Java\openJDK8\bin\java.exe" -jar "c:\Program Files (x86)\EXASOL\EXASolution-6.0\EXAplus\exaplusgui.jar"  
View full article
Here is a list of lessons we learned while migrating our reporting tools from MySQL (5.6 with strict mode off) to Exasol.
View full article
 In order for the Exasol Database to use a JDBC Driver in IMPORT or EXPORT commands, the JDBC Driver must support certain methods.
View full article
This article shows you how to set up a cron job to schedule database jobs
View full article
This article shows how to set up a Python UDF to test HTTP connectivity.
View full article
This article specifically describes how to create JDBC logs when connecting to a JDBC source for an IMPORT or EXPORT statement
View full article
This article explains how to set up Exasol as a Linked Server in SQL Server
View full article
This article shows you a way to load data between Exasol and Google Bigquery faster than regular JDBC EXPORT
View full article
If you are have issues with special characters when connecting to Exasol in PHP, this article describes a potential solution.
View full article
This article shows you how to start Exaplus CLI in Background Mode on Linux
View full article
This article helps identify and troubleshoot Exasol connectivity issues.
View full article
BACKGROUND To export CSV files from IBM DB2 Options to export csv from IBM DB2   Option 1: Using the   IBM command line processor: Connect to the database you want to export.   Use the EXPORT TO-command combined with a SELECT query to export a table (Documentation:   https://www.ibm.com/support/knowledgecenter/SSEPGG_9.8.0/com.ibm.db2.luw.admin.cmd.doc/doc/r0008303.html ) We recommend to apply following parameters to ensure compatible formatting for your exported csv file: o   MODIFIED BY datesiso -> exports dates in ISO format (YYYY-MM-DD) o   MODIFIED BY timestampformat=”YYYY-MM-DD HH:MM:SS” -> exports timestamps in selected format o   COALESCE(column,’’) -> checks if content of data field equals   NULL   and replaces it with “” (empty string) if necessary. This addition is needed for every selected column that allows   NULL   values. Example: Additional Notes: IBM command line processor   automatically masks double quotes ("Example" -> ""Example"")   Option 2: Using the   IBM Data Studio: Connect to the database you want to export Select the table you want to export Open context menu by right clicking on the table Select the option   Unload   ->   With Export Utility   to open the integrated export tool Select   JDBC   as   Run method Pick your path and file name for the csv file To specify additional options, select the tab called   Options   (top left) To ensure a compatible format for your csv file, you should check the available control boxes as follows Click  Run  to start exporting the table You will find the csv file in your selected path Additional Notes: IBM Data Studio   automatically converts   NULL   to "" (empty string) IBM Data Studio   automatically masks double quotes ("Example" -> ""Example"")
View full article
This article describes enabling ODBC logs for Tableau.
View full article