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...
Hello everybodyMy name is Gallus. I introduced EXASOL in my previous
company in 2012 and worked happely with it for almost 4 years. In my
current position as Datawarehouse architect at Helsana Health-Insurance
I re-evaluated EXASOL, did a POC and we ...
Hello We stopped discovering files, that did not lead to the result we
expected. Instead we have started defining an interface specification in
csv/xls, this contains all the required information (and can in must
cases directly be generated from the ...
Yes, we do something similar, we actually have >2'000 small files (10-50
rows) which we want to load all into the same table, each of the files
has 2 header rows(1 row column names, 2 row datatype definition). The
files reside on an sftp-server.We ha...
Hello NituWakanWhen we started with the migration from Teradata to
Exasol Wherescape's standard for Exasol was also PowerShell. We
absolutely did not like this approach, because we didn't want to
introduce another language, it was not transparent and...
Hello ChrisDefinitely, however I would suggest that we first show that
it works. Therefore I would suggest that we wait until we have at least
one part of our datawarehouse in production (the plan was to have the
first part by end of October in produ...
Hello ValerieMany thanks. This makes it easier to select the right
tool/language for the right purpose. As we are about to introduce EXASOL
in our company I was asked a lot which language we should choose.Kind