Skip to content

ETL

Metadata-driven pipelines : la continuité du Master Package SSIS

Organiser des flux, c’est une question qui m’a accompagné tout au long de ma carrière. Quand j’ai commencé avec les ETL, j’ai appris “à l’ancienne” : toutes les règles de gestion codées directement dans les packages. Une approche rigide, lourde à maintenir, et qui surtout créait une dépendance forte de mes clients envers moi. Assez vite, j’ai développé une autre… 

Oracle Technology Roundtable for Digital Natives – Let’s have a look at AI, Cloud and HeatWave

Yesterday I participated to the Oracle Technology Roundtable for Digital Natives in Zurich. It was a good opportunity to learn more about AI, Cloud and HeatWave with the focus on very trendy features of this product: generative AI, machine learning, vector processing, analytics and transaction processing across data in Data Lake and MySQL databases. It was also great to share… 

Apache Kafka and ksqlDB

After two introduction blogs on Apache Kafka (ie. Apache Kafka Concepts by Example and Apache Kafka Consumer Group), it is time to discover the wide ecosystem around it. In this blog post, I will play with ksqlDB, streams and tables. ksqlDB ksqlDB is a server that takes benefit of an Apache Kafka infrastructure for real time data streaming. It can… 

Elasticsearch, Ingest Pipeline and Machine Learning

Elasticsearch has few interesting features around Machine Learning. While I was looking for data to import into Elasticsearch, I found interesting data sets from Airbnb especially reviews. I noticed that it does not contain any rate, but only comments. To have sentiment of the a review, I would rather have an opinion on that review like: For that matter, I… 

Oracle Data Integrator – The EL-T tool from Oracle

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 and that allows the integration of data coming from another sources.  Agility of use Oracle Data Integrator uses various types…