About Gallus

Gallus · 05-10-2021

We have the case that we have an application in the cloud (CRM Dynamics), wich uses Microsoft Data-Export-Services to export the Data from the CRM Application into an MS SQL Database in the Azure cloud.We would like to import the data from this Azure...

Gallus · 09-07-2021

Hello everybodyI am using an export statement to store the records of a table into multiple files. I noticed that the size of the files and also the number of records per file is not equal and varias quit a bit. In the EXASOL documentation I found th...

Gallus · 15-06-2021

Hello togetherWe have in our company a team, which needs to access the EXASOL database using Oracle Data Integrator (ODI). They only need to perform simple "Select" Statements from views. We were able to somehow setup the ODI Topoligy (using the last...

Gallus · 08-06-2021

We are migrating from another database to EXASOL. The default behavior for order by statements of that database corresponds to the option order by xxx desc nulls last in EXASOL.The question came now up whether we could in EXASOL define the "nulls las...

Gallus · 11-09-2020

We are using Wherescape as our ELT Tool and are currently on Teradata. The key point about Wherescape is, that it generates platform specific code. We write our logic on the Metadata and then Wherescape translates it to almost any target platform, us...

Gallus · 06-10-2021

Hello @exa-Kristof and @exa-Nico Many thanks for your answers, this helped me. I usually go to the exasol-documentation website (https://docs.exasol.com/home.htm), from there I was not able to find these links. I usually don't go directly to github. ...

Gallus · 20-07-2021

Good Morning everybodyMany thanks for all your help. This helps definitely. As we have 17 nodes I am going to check with the recipient whether it would also be possible to deliver 17 files or whether they can deal with different file sizes. I assume ...

Gallus · 09-07-2021

Hello @mwellbro Many thanks for your answer. I have just tried it with an order by statement, but that did not change anything.Kind RegardsGallus

Gallus · 15-06-2021

Hello togetherMany thanks for your feedback. We decided not use the SQL Preprocessor at this point in time. Some of the arguments against it:Performance: At this point in time we don't have the time to do detailed performance testingLack of clear spe...

Gallus · 08-06-2021

Hello UweMany thanks for the answer. I hesitate a bit to apply this in the preprocessor as this would then be applied to each and every query. I will first check with our internal community to better understand the benefit vs. the cost. We would then...

User Statistics

User Activity

Importing From MS SQL Server - Datatype Mapping

Export to multiple files, controle the number of records per file

Using Oracle Data Integrator with Exasol. Problems with decimal (14,4)

Defining order by null last at database level

Wherescape and EXASOL

Re: Importing From MS SQL Server - Datatype Mapping

Re: Export to multiple files, controle the number of records per file

Re: Export to multiple files, controle the number of records per file

Re: Defining order by null last at database level

Re: Defining order by null last at database level

New to the Exasol Community?