Development & Performance APEX Connect 2017 – Day 2 10.05.2017 by Alain Lacour After the Keynote about “Oracle Application Express – Ahead of it’s time. Leading the way forward” by Joel Kallmann (Director of Software Development for APEX) and some overall presentation about Development with APEX 5.1, I decided to attend presentations on(…)
Development & Performance APEX Connect 2017 – Day 1 09.05.2017 by Alain Lacour This year again the APEX connect conference spans over three days with mixed topics around APEX, like JavaScript, CSS, SQL and much more. After the welcome speech and the Keynote about “Reconciling APEX and the Thick Database Paradigm” by(…)
Development & Performance APEX Connect 2016 – Day 2 – APEX 27.04.2016 by Alain Lacour After the great Keynote about “APEX Vision, Past, Present, Future” by Mike Hichwa, the father of APEX, I decided to attend presentations on following topics: – Dynamic Actions 5.1 – APEX and Oracle JET – Enterprise UX(…)
Business Intelligence Oracle Data Integrator – The EL-T tool from Oracle 12.11.2015 by Alain Lacour Oracle Data Integrator is the ETL tool that Oracle has developed to enter into the world of Business Intelligence. Taking advantage of its incredible experience in database managing, Oracle has created an ETL tool that is flexible to use, powerful(…)
Business Intelligence QlikView Tips & Tricks: The Link Table 12.06.2015 by Alain Lacour In this blog, I will show you how to bypass a “Synthetic Key” table in QlickView. Why bypassing a “Synthetic Key” table? If you have multiples links between two tables, QlikView generates automatically a “Synthetic Key” table. (here “$Syn 1”(…)
Development & Performance SAP HANA SQL scripting optimization: the CE Functions 12.06.2015 by Alain Lacour In SAP HANA, you have two possibilities to create the Calculated Views: Using the graphical method Using the scripting method with CE functions In this blog, I will demonstrate that CE Functions can improve performances from a Calculated(…)
Development & Performance Row Store vs Column Store in SAP HANA 21.05.2015 by Alain Lacour The SAP HANA database allows you to create your tables in Row or Column Store mode. In this blog, I will demonstrate that each method has its advantages and disadvantages and should be used for specific cases. Thanks to two(…)
Enterprise content management QlikView – Load data in QlikView / QlikSence – Best practice and trick 14.04.2015 by Alain Lacour In this blog, I will give you some best practices and tricks when you are loading table to generate your data. But before, I will review the different ways to load data in a QlikView or QlikSense report. 1.How to(…)
Enterprise content management QlikSense – The easy way to create a QlikView report 07.04.2015 by Alain Lacour Today, one of the most used Business Intelligence products is undoubtedly QlikView. This Swedish product is one of the best positioned in the Gartner Magic Quadrant for Business Intelligence and Analytics Platforms matrix and has been for a number of(…)
Enterprise content management Birst: an attractive “all-in-one” Business Intelligence solution 29.01.2015 by Alain Lacour The review of the Gartner Magic Quadrant for Business Intelligence and Analytics Platforms has revealed a new challenger that could become one of the leader of this market: Birst – an interesting “all-in-one” BI solution.