Paranoid? Masking, anonymizing, and obfuscating PII in XML and JSON data

Data masking, anonymization, and obfuscation are methods to scramble personally identifiable information (PII). We can apply different techniques to mask data, e.g. you may substitute values (swap na for another)…
Amar Manipatra April 1, 2019

Converting clinical trials XML data to Snowflake and Quicksight with Flexter

In this blog post we will show case Flexter, Sonra’s ETL tool for complex XML/JSON data standards. We will convert a large number of XML documents into a relational data…
Uli Bethke March 22, 2019

Converting IRS Form 990 XML to text and Excel

In 2016, the IRS released data in electronic form to the nonprofit sector. Each of these files, contains data about nonprofit finance and more. You can get all that data…
Uli Bethke December 18, 2018

Converting NETCONF XML to SQL Server tables

In this guide we will show you how to process NETCONF XML files with the enterprise version of Flexter and convert it to SQL Server. NETCONF XML The Network Configuration…
Uli Bethke June 27, 2018

Converting and analysing Rugby JSON data to Oracle Data Visualization Desktop

Here is another post that will show how you can work with the output from Flexter to analyse your data. In this post we will show you how to convert…
Uli Bethke May 22, 2018

Converting FPML XML to Oracle

In this guide we will show you how to process FpML XML files with Enterprise Flexter and convert it to Oracle. FpML XML Standard FpML (Financial products Markup Language) is…
Uli Bethke May 8, 2018
spinner