Extract JSON Data with Automatic Enforcement of Collibra Policies
Overview
Bluemetrix’s integration with Collibra and ER/Studio from IDERA enables data team to accelerate nested JSON data extraction into relational tables (i.e., Snowflake, BigQuery, etc.), whilst automatically enforcing governance policies in Collibra.
In just a few clicks, your team can reverse engineer JSON and create logical and physical models in ER/Studio. Map it all to Collibra terms and load a model into the Collibra data catalog. Instantly design and deploy a relational database, no matter the data warehouse or storage technology. Use Bluemetrix to create ETL pipelines that extract the data into the relational tables, while automatically adding security policies on the data as defined in Collibra.
By using these automation capabilities, your BI tool users and data analysts have the power to effortlessly execute standard queries against the normalised relational data, expediting access to the data and taking full advantage of the scale, speed and flexibility of your data warehouse.
For a detailed feature set about this integration, please refer to the attached datasheet and/or video.
Media
More details
Release Notes
- Direct integration with Collibra 5.7 or newer
- Business glossary mapping in Collibra Catalog
- Reverse engineer JSON data to create physical and logical data models in ER/Studio
- Transform hierarchical models to relational models
- Generate schema for target databases with code generation
- ETL pipeline creation in BDM
Compatibility
- Collibra Data Intelligence Cloud
- Collibra Data Intelligence On-Prem
Dependency
- N/A
License and Usage Requirements
Community
See existing Q&A in the Collibra Community
Browse discussions with customers who also use Partner Offerings from the Collibra Marketplace.
Start a New Topic in the Collibra Community
Collibra-hosted discussions will connect you to other customers who use this app.
Vendor supported resources
Bluemetrix provides a range of different support policies ranging from basic Internet Support to Managed Services where we take control of the data environment for our customers at https://bluemetrix.atlassian.net/servicedesk/customer/portal/2
During business hours: weekdays from 8 am to 7 pm GMT+1, with 12 hours response time
For more information, please contact
Liam English
5th Floor, River House, Blackpool, Cork, T23 R5TF, Ireland
As a prerequisite, customers need to have both Collibra Data Platform, ER/Studio from IDERA and Bluemetrix Data Manager.
Please contact our sales team for further details about licensing.