About Gallus

Gallus · 16-11-2021

Good morningWe receive from an external source files wich are comma (",") separated and the text fields all start and end with double quotes. however in one of these text fiels there are CRLF. It looks something like the following ," bla bla bla blab...

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 everybody I 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 t...

Gallus · 15-06-2021

Hello together We 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 las...

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 la...

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

import from csv text-field containing crlf

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

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?