Table of Contents Table of ContentsBackgroundHow Transaction Collisions
OccurPotential Strategies to Avoid Transaction ConflictsPerform
Rollbacks on Database ObjectsLock Tables Required for Transactions in
AdvanceUse EXPORT or IMPORTAdditional Refere...
Problem If you create a user using LDAP, a simple connection check to
the LDAP server is performed. Basically Exasol tries to connect to the
LDAP server with a bogus user and checks that access is denied. This
check might produce false negatives in c...
Background In some use cases, you may want to enable internet access for
your community edition so that you can load publicly accessible data
sets, for example. This article will show you how to do this using
VMWare. A similar article exists already ...
Background With the help of the below scripts, you can set up an
automatic synchronization of LDAP/AD Groups with Exasol users and roles.
Prerequisites Add the distinguished name of the corresponding LDAP
(Active Directory) group as comment on all da...
Question I want to run a query or job regularly, without having to do
this manually. How can I schedule these to run automatically? Answer
Exasol does not offer an in-database scheduler. There are a variety of
3rd party tools that you can use to sche...
Hi @vidhyasagar , most SQL clients also offer this ability. In
DBVisualizer, for example, you can right click on your schema and choose
"EXPORT SCHEMA". With these settings, you can export the entire DDL of
the schema into a file (not including the d...
The visibility of EXA_ALL_ROLES is not configurable. To change it would
be an entire new improvement request/feature, but to be honest, I'm not
sure if it makes sense in this case. Simply knowing the role name and
that the role exists does not necess...
Hey Mark! I've only done this once and it was a while ago, but I think
the instructions are still valid. You need to add the following to your
connection string: domain=AD;useNTLMv2=true; So whatever your domain is
called (mine was called AD), then y...