Converting MedlinePlus XML to QlikView

Uli Bethke XML, XSD

MedlinePlus is the National Institute of Health's Web site for patients and their families and friends. Produced by the National Library of Medicine, the world’s largest medical library, it brings you information about diseases, conditions, and wellness issues in language you can understand. MedlinePlus offers reliable, up-to-date health information, anytime, anywhere, for free. MedlinePlus XML Format Guide MedlinePlus publishes three ...

Convert MISMO XML to Hive and Parquet

Anvesh Gali XML

In this walkthrough, we will convert the MISMO (The Mortgage Industry Standards Maintenance Organization) XML files to Parquet and query in Hive. The XML files are converted to Parquet using the enterprise version of Flexter. The enterprise version provides users with numerous additional features which aren’t available on the free version of Flexter (try for free). In the following steps, ...

Let's talk Kafka Streams

Anvesh Gali Uncategorized

Look Ma, no Code! Building Streaming Data Pipelines with Apache Kafka, Robin Moffatt, Technology Evangelist, Confluent Companies new and old are all recognising the importance of a low-latency, scalable, fault-tolerant data backbone, in the form of the Apache Kafka streaming platform. With Kafka, developers can integrate multiple sources and systems, which enables low latency analytics, event driven architectures and the ...

Comparing Window Function Features by Database Vendors

Jiří Mauritz Data Warehouse, Redshift, SQL for Analysis, Window Functions

We will round off the series on window functions with comparison of what database vendors offer. There are various mutations of window functions and every vendor supports a different subset or feature. Some also add extra window functions or features beyond standard ANSI SQL. One of the most powerful features is user-defined aggregate functions (UDAF), which some databases allow using ...

Convert IRS XML to PostgreSQL using Flexter Enterprise

Anvesh Gali XML

Loading IRS Data into PostgreSQL database using Flexter Enterprise In this walkthrough, we load the IRS XML files into PostgreSQL database using Flexter Enterprise edition. Flexter Enterprise provisions users with all features. The enterprise version provides users with numerous additional features which aren’t available on the free version of Flexter. Features Free Online Trial Enterprise Version Max daily data limit ...