utPlsqlXl @utPlsqlXl

Especially for complex unit-tests (like ETLs) you really need something to define your tests. Thats Excel, generating utplsql. downsirion.de Joined May 2017

Tweets

29
Followers

102
Following

8
Likes

7

utPlsqlXl @utPlsqlXl

4 months ago

Want to Test powerbi? I dont know really how. So I told the Team to move all etl stuff like pivoting deduplication Filter joins whatever into database views and use powerbi only for visualization. Which is I guess best Design pattern. Now we have good Performance and Tests.

0 0 0 53 0

utPlsqlXl @utPlsqlXl

5 months ago

I told the Team, give me your Most complex etl Statement which you think you can not unit test. They gave me 600 line Statement with 70 joins in it. I was glad to do it. Took me about 10 hours But finally I did it and found 10 unused joins and several weird codings. Tschakka.

0 0 0 49 0

utPlsqlXl @utPlsqlXl

10 months ago

Today concert in munich laim. So proud to present our new program

0 0 0 61 0

Download Image

utPlsqlXl @utPlsqlXl

2 years ago

Succesfully migrated utplsqlxl to EXASOL/python solution, and now building up regression testing. I shall introduce this approach now to other teams in this banking-company with other databases and development processes. It works. It rocks! Not only for Oracle. #TDD #Unittest

0 0 0 115 0

utPlsqlXl @utPlsqlXl

2 years ago

accidently insert DATE into VARCHAR2 and its implicitly converted to varchar. hm. test_varchar VARCHAR2 INSERT INTO POS_TEST (test_varchar) VALUES (TO_DATE('01.01.2019', 'DD.MM.YYYY')); SELECT * FROM POS_TEST; 01-JAN-19 ok why not..

0 0 0 59 0

utPlsqlXl @utPlsqlXl

2 years ago

yeah its done. Proudly present our first Studio CD. Its songs about Tolkien's Silmarillion. music.amazon.de/albums/B0C87NH… #Silmarillion #Tolkien open.spotify.com/intl-de/artist…

0 0 0 198 0

utPlsqlXl @utPlsqlXl

3 years ago

Yeah, the TestExcel goes now #EXASOL ! Finally got the confirmation to migrate logic from Oracle/utplsql to Exasol! so if anyone has EXASOL/python... i guess in 1-2 month we can talk about introducing test-driven development in your company. #tdd #dwh #test #unittest

0 0 0 194 0

utPlsqlXl @utPlsqlXl

3 years ago

Anybody Interested in complex etl plsql unit Testing? I I would have some additional time to Support..

0 0 3 0 0

utPlsqlXl @utPlsqlXl

5 years ago

after many years succesfull implementing DWH unit-tests for Oracle with utplsql and Excel I am searching now for new customers to introduce continous integration within DWH.. I would be available starting with 01.04.2021 so feel free to contact me

0 0 0 0 0

utPlsqlXl @utPlsqlXl

7 years ago

I started with migrating the testexcel from utplsql2 to utplsql3 (but will take a while), just wanted to know if somebody is waiting for it here in twitter, because some guys were asking for testexcel but were using new version3 of utplsql ... #utplsql

1 0 1 0 0

utPlsqlXl @utPlsqlXl

7 years ago

now i migrated the testexcel macros from oo4o (which are deprecated since 11g) to ADO objects, so testexcel will now work on oracle 12+ clients again without doing some manual installation steps with odac components etc... #utplsql #tdd

0 0 2 0 0

utPlsqlXl @utPlsqlXl

7 years ago

for those who wants to improve unit-testing plsql: lets talk together about your experiences about testing plsql code. doodle.com/poll/v5iqihzhq… … we will talk about using excel and other tools for testing #utplsql #tdd #plsql

0 0 3 0 1

utPlsqlXl @utPlsqlXl

8 years ago

ever tried something like this: select to_date('2000#12*14', 'YYYY-MM.DD') from dual; i would expect an error, but it seems to be "ok"... (at least on oracle 11.2) #SQL

0 0 0 0 0

utPlsqlXl @utPlsqlXl

8 years ago

YES! we did it... migrated over 500 informatica mappings and 200 workflows into plsql and airflow as new scheduler. the new workflows are running now! and just in time... 2 weeks left now before old informatica server is shot down. excellent planning over 9 month.

0 0 0 0 0

utPlsqlXl @utPlsqlXl

8 years ago

some impressions of our first gig... vimeo.com/243501090

0 0 0 0 0

utPlsqlXl @utPlsqlXl

8 years ago

for those who wants to improve unit-testing plsql: sorry that i had to cancel the last follow up meeting. next one would be on monday... doodle.com/poll/v5iqihzhq… we will talk about using excel and other tools for testing #utplsql #tdd #plsql