Business Intelligence (BI)
Power BI is a business analytics and data visualization package from Microsoft that can provide custom-designed dashboards and reports ready for web or mobile display. Like other BI and analytic tools, Power BI can also perform simple data wrangling jobs like sorting and aggregation before and after the data are displayed.
Read More
ETL
Connecting to and working with data in an Snowflake AWS database from IRI Workbench (WB) is no different than with an on-premise SQL-compatible source. You browse Snowflake tables and exchange metadata in Workbench via JDBC.
Read More
Data Masking/Protection
Once a Schema Pattern Search is performed in IRI Workbench (WB), the results can be used by the Schema Pattern Search to Data Class Association wizard to assign data classes to the matched columns.
Read More
IRI Workbench
This article covers the creation and use of remote server connections from IRI Workbench so you can run CoSort (Voracity), FACT, NextForm, FieldShield, or RowGen scripts on other computers.
Read More
Big Data
Many of the same data manipulation, masking, and test data generation jobs you can run in IRI Voracity® with the default SortCL program can now also run seamlessly in Hadoop™.
Read More
Big Data
Among the many database-centric features in IRI Workbench is the ability to create, modify, and execute SQL statements manually or graphically. These “SQL scrap-booking” features are available through the free Data Tools Platform (DTP) plug-in for Eclipse, which also supports IRI job wizards for database:
profiling, searching, classification, E-R diagramming, and integrity checking integration, including ETL, pivoting, slowly changing dimensions, and change data capture column masking, including format-preserving encryption, redaction, and pseudonymization subsetting, test data generation, and bulk loading migration, replication, and offline reorgsTo use the cross-platform(!) SQL and IRI facilities in Workbench, you must first make a JDBC connection1 to your database from the DTP’s Data Source Explorer view.
Read More
DAM/DAP
IRI Chakra Max is data-centric audit and protection (DCAP) software for managing and protecting information in your databases. It does so through:
Setting database access permissions Controlling SQL statements so only approved syntax on tables is allowed Masking sensitive data dynamically as it is extracted from a tableIn this article, we focus on the creation and application of a dynamic data masking security policy in Chakra Max.
Read More
Data Migration
Data replication means copying data from one place to another, and is usually done between users of different databases who need to share the same level of information.
Read More
Data Transformation
Talend has been on the market for a few years now, and its flexible UI components make it a very reasonable choice for developers when it comes to customization.
Read More
IRI Workbench
As we transition IRI Workbench to the Neon version of Eclipse™ in 2017, the Easy Shell feature that facilitated command-line executions of job and batch scripts will no longer be available.
Read More