Connector for EXASOL Database [DONE]

Feature requests
1

Hello easymorph team,

It would be great if you could integrate an Connector for EXASOL Database https://docs.exasol.com/sql_reference.htm

We are using EXASOL at enterprise scale and to make it more accessable for every day users easymorph could be the solution. Unfortunatly there is no support yet.

Kind regards

Markus

1 Like
2

Isn’t it possible to use the standard ODBC driver? I will try tommorow at work as we also have an EXASOL database in use. I will keep you informed…

Best regards,

Jochen

3

Hi Jochen,

Thank you for your reply.
ODBC is possible, but it lacks the SQL dialect. Unfortunately the visual query editor is not available for “other SQL”. That is quite a important feature in my case. We try to get rid of the need to write SQL for the user group in mind.

To me it does not matter whether a connector or a SQL dialect is the solution for the problem.

Kind regards,

Markus

4

Hi all,

There’s a specific feature in Exasol to import data from flat files. The use of this function would be great.

Regards

5

EXASOL seems popular. We will bump it up on our product roadmap.

2 Likes
6

Hi all,
is there an update to this? Where on the product roadmap is the Exasol dialect or Exasol connector currently?

Regards

7

Greetings,

Exasol is important for me also.

Regards

8

We’ve put the EXASOL connector on the roadmap for release 4.6.1. We didn’t do our research on EXASOL yet, but if no major roadblocks encountered it should be available by the end of December.

We might reach out to you for beta-testing.

9

greetings,

there’s a specific loading mode in Exasol that makes it very fast. maybe you could consider this possibility ?

regards

10

We will definitely consider it, but the result depends on whether it’s supported in the .NET or ODBC drivers provided by the vendor.

11

the IMPORT method only works with JDBC or flat files…

12

Nudge EXASOL for better .NET support :slight_smile: We can’t do much if they don’t support the feature in their ADO.NET or ODBC driver.

We’ll see what can be done with files. Maybe they can be served from EM Server. Otherwise, only file transfer + local load via existing actions.

13

An SQL dialect for Exasol has been added in version 4.6.2. It’s supported in the visual query editor and in all the database actions except the “Bulk export” action.

@mhaindl, @Jochen_Marquardt, @cvo Please confirm if it works as expected or not.