About exa-Nico

exa-Nico · 22-06-2021

Background Sometimes, you want to set up a JDBC connection to your SQL Server database, but the SQL Server database only allows Windows Authentication (or the user you are trying to use is configured for Windows authentication). Windows authenticatio...

exa-Nico · 08-04-2021

Table of Contents Table of ContentsScopeDiagnosisExplanationRecommendationAdditional References Scope When executing a query, you might receive an internal server error. This article will show you what information you need to investigate it. Diagnosi...

exa-Nico · 18-03-2021

Table of Contents Table of ContentsScopeDiagnosisExplanationRecommendationAdditional References Scope This article describes how to fix some syntax errors with Scripts when using DbVisualizer. Diagnosis When trying to create a script using DbVisualiz...

exa-Nico · 25-02-2021

Table of Contents Table of ContentsScopeDiagnosisExplanationRecommendationAdditional References Scope While loading data from one Exasol database into another database, you may get connection issues. This article will describe how you can resolve the...

exa-Nico · 24-02-2021

Background Exasol's UDF scripts make it possible to run machine-learning algorithms directly in the database. The training of a random-forest model and using this model to make predictions on a dataset in the Exasol database can be done in three step...

exa-Nico · 06-10-2021

I would love that, but like always, there are some other technical dependencies that make it challenging. For a quick "win" though, we can enhance pages like this and make it more explicit that the github repos also contain data type mapping informat...

exa-Nico · 05-10-2021

Hi @Gallus , We have some migration scripts which also do some explicit data type mapping here: https://github.com/exasol/database-migration/blob/master/sqlserver_to_exasol.sql For example, bit is mapped to DECIMAL(1,0) and bigint is mapped to a DECI...

exa-Nico · 27-09-2021

In addition to what Kristof said: Exasol will create all necessary indexes on the first run of a query. So on the second run of the query (assuming the first query committed), it can use the index and therefore have much better performance than the f...

exa-Nico · 24-09-2021

@Hitesh_Sajnani you have a very keen eye 😉. Yes the documentation was updated a few days ago to specify that additional requirement. Sorry for the inconvenience it caused before though!

exa-Nico · 16-09-2021

Hey @drumcircle - I've created a ticket to update https://docs.exasol.com/administration/on-premise/installation/system_requirements.htm accordingly!

User Statistics

User Activity

Windows Authentication with SQL Server

Internal Server Errors

DbVisualizer: Syntax Errors with Scripts

IMPORT FROM EXA: Connection Errors

Machine Learning Example in R and Python

Re: Importing From MS SQL Server - Datatype Mapping

Re: Importing From MS SQL Server - Datatype Mapping

Re: parallel query performance issue

Re: Exasol 7.1 - Connection Security Changes

Re: Nvme drives

New to the Exasol Community?