Background Filter on DOUBLE columns returns unexpected results. The DOUBLE values you see in EXAplus may differ from the actual database values due to the JDBC double handling and rendering. Explanation As the DOUBLE data type is only an approximativ...

Background Below is an UDF script in R that executes a scoring model inside EXASOL. While example is using the flights dataset from R and applying a randomForest model, it may be used as a template for R models. It has already proven in a real case w...

Background Hadoop ETL UDFs are the main way to load data from Hadoop into EXASOL (HCatalog tables on HDFS). In order to deploy the ETL UDFs, you need to set up the connectivity between EXASOL and Hadoop. This SOL describes the network requirements to...

Background Although it is possible to directly access and copy the internal database table of an SAP system, this manual process is tedious and error-prone.Using a 3rd party product instead ensures data consistency, provides means for automation and ...

Background To export CSV files from Microsoft SQL Server Options to export csv from Microsoft SQL Server Option 1: Using the SQL Server Import and Export Data Wizard / DTSWizard (tool should be included in your SQL Server installation): Open the wiza...