Big Data
An operational data store (or “ODS”) is another paradigm for integrating enterprise data that is relatively simpler than a data warehouse (DW). Read More
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 cloud data warehouse powered by an AWS Snowflake database from the IRI Workbench IDE is no different than with an on-premise SQL-compatible source. Read More
IRI Workbench
This article covers the creation and use of remote server connections from IRI Workbench so you can run CoSort (Voracity), 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(!) 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 several 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
ETL
Batch files contain commands in plain text that can be executed by the command line interpreter of the operating system to accomplish a specific purpose. Windows batch files usually have an extension of .bat Read More