Mining/Other Natural Resource Industry: environmental hazard reduction, cost benefit and quality control.
Epitech’s Integrator is especially useful for blending and configuring resource or mining data in public, private or proprietary formats.
Data is then ready to provide insight or yield ROI for efforts in lowest risk, highest return on eg. mineral extraction and preparation for processing. As the software can be run on an automated (just in time) or scheduled basis, data is prepared for the time of greatest convenience or economy.
Other examples would include integrating all the mineral production and assay results for both mining and prospecting data with production costs at each site. This would enable users to establish which future prospects will cost the least to produce higher grade product. This would be useful for geologists, assay lab technologists and engineers.
Companies can also integrate the value added to cost of production by adding successive safety measures for continued worker productivity. Production managers would likely be the best supported for this use.
These integrations are shielded from the risk of data theft or tampering as they are available only on the user’s desktop or LAN. Should the user wish to store them in the Cloud they can be anonymized prior to upload and portions of tables extracted as separate secured entities.
Multi-database
Ease of Use
Drag and Drop Field Mappings
Filter Incoming Data
Data Conversion (Resolutions)
Data Restore (Rollback) on Error
Manual ETL Processing
Scheduled ETL Processing
Clean Insert Option
Insert Only Option
Insert & Update on Primary Key Collision Option
HIPAA and GDPR Compliant
Powerful Query Engine
The Integrator can transfer data from the following:
MS Access | MS Excel
Oracle
IBM DB2
MS SQL Server
MS Access | MS Excel
MySQL
XML
Text: CSV (Comma-Separated Value) files
Text: Tab-delimited files
to the following:
MS Excel
Oracle
IBM DB2
MySQL
XML
Unlike other products, the Integrator is inexpensive, can be used “out of the box” with only a “QuickStart” guide; and provides data cleansing, sorting and other preparation in a secure local environment.
This is a tool for many different scenarios, from health to industry, natural resources to shipping, and has the attachments to deal with whatever form the data arrives.