Automated SQL to Solr mapping: take the time and complexity out of moving data to Solr 

VIP takes the time and complexity out of moving SQL data to Solr, automatically mapping data based on DIH configuration files. A high-speed workflow then moves data into Solr servers automatically, providing access to the data needed to build quality systems using Solr. 

Too much data, not enough time? 

Solr offers a cutting edge, open source data search and indexing technology, used widely across business-critical systems today. However, its ability to process vast amounts of data in real-time can create testing and development delaysSolr development requires constant access to vast quantities of data, populated on demand into parallel environments. The data must be drawn from numerous different sources, requiring complex data mapping and alignment. Relying on manual processes to map and move the data risks misalignment and lengthy delays, as bugs makit into Solr systems due to a lack of available test data. 

Meetup recording – test automation for Solr 

Automatically move data from SQL to Solr  

VIP, Curiosity’s high-speed and fully customisable workflow engine, removes the delays caused when moving data from SQL to Solr servers. An automated workflow reads a DIH configuration file to map data from SQL to Solr, reliably moving data without the delays caused by manual alignment. A rapid utility then generates the config file needed to perform parallelised loads, quickly moving hundreds of thousands of rows of data. VIP validates data for compatibility issues as it moves, providing accurate test and development data without the delays associated with complex data provisioning. 

Solr data provisioning test data automation

See the Full demo – mask, subset and augment Solr data on demand.

Take the time and complexity out of moving data to Solr 

Watch this short demo of VIP’s high-speed SQL to Solr utility to see how: 

  1. An automated VIP workflow uses a DIH configuration file to map SQL data to Solr, consistently moving data with slow and erroneous data alignment. 
  2. A rapid utility generates a database config file to move data to Solr servers, performing parallelised data loads in just a few clicks. 
  3. VIP validates data for compatibility as it moves from SQL, avoiding the bugs and delays created as misaligned data is moved into Solr environments. 
  4. The high-speed utility can be embedded seamlessly within complete Test Data Automation for Solrpopulating masked and augmented test data into QA environments on demand. 

Book a free consultation