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 BackgroundPrerequisitesWindows Authentication with the Official SQL Server DriverStep 1: Disable Security ManagerStep 2: Create ConnectionStep 3: Test your connectionWindows Authentication with JTDS driverStep 1: Create ConnectionSt...

exa-Nico · 18-03-2021

Table of Contents BackgroundPrerequisitesWindows Authentication with the Official SQL Server DriverStep 1: Disable Security ManagerStep 2: Create ConnectionStep 3: Test your connectionWindows Authentication with JTDS driverStep 1: Create ConnectionSt...

exa-Nico · 25-02-2021

Table of Contents BackgroundPrerequisitesWindows Authentication with the Official SQL Server DriverStep 1: Disable Security ManagerStep 2: Create ConnectionStep 3: Test your connectionWindows Authentication with JTDS driverStep 1: Create ConnectionSt...

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 · 02-07-2021

This article (and corresponding scripts) has been updated. All the scripts are now in Github. In addition, the scripts have the following changes: Created HELPER script to help debug problems with AD attributes improved error handling in all Python s...

exa-Nico · 16-06-2021

@mwellbro we are working to move all of the scripts to Github for exactly that reason 😁

exa-Nico · 14-06-2021

got it, thanks! Try to add port 3306 for both guest/host in your VM network settings (Network -> Adapter 1 -> Advanced -> Port Forwarding. Your port forwarding rules would look like this: Hopefully this will let you connect back to your local machine...

exa-Nico · 13-06-2021

Hi @Uthsavi - The IP Address (127.0.0.1) refers to localhost, and in the connection in the database, that would basically mean you have a mysql server running on the same VM or machine that your Exasol environment is running, which is probably not th...

exa-Nico · 21-05-2021

I'll try to remember! In general yes, the slave segment is on the neighboring nodes, but if you do these actions in a specific order when setting it up, they are mirrored on the other nodes. I don't know too many details on how it exactly works yet a...

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: Synchronization of LDAP / Active Directory Groups and Members to Exasol Database Users and Roles

Re: Create DDL for the entire Database

Re: MySQL - communication link failure, the driver has not received any packets from the server

Re: MySQL - communication link failure, the driver has not received any packets from the server

Re: Synchronous Dual Data Center (SDDC)

New to the Exasol Community?