What is DVS?
Automate, simplify, accelerate, visualize the ETL testing process.
All data warehouse projects have composite and collaborated data models that capture the entire data of organizations.
It brings data together from heterogeneous sources in to the one single destination. It does not only bring data together, but the data also extracted, transformed and then loaded in to the data warehouse.
That is, there is a huge amount of organizational data movement in ETL process. In this data organization, senior managers should have the ability to monitor historical trends, patterns and then provide healthy conclusions. Therefore, checking on voluminous organization data becomes very important. At that point, DVS plays an important role.
DVS, built specifically to automate, simplify, accelerate, visualize the ETL testing process and measure DW Quality.
DVS, ensures that the data extracted from sources remains intact in the target by analyzing and pinpointing any differences. DVS, improves your data quality as side result.
Comprehensive Test Types
DVS, ensures that the data extracted from sources remains intact
Integrity test consists of null value checking, unique key control, duplicated data recognizing and metadata control.
Data Profiling test consists of row-count checking, domain control, max/min value checking and pattern control.
Parent child test that check parent child relationships between tables in DWH is so crucial for RDBMS.
A comparison test is so important after ETL process in DWH. Missing data, data type mismatch, transform error, not matched pattern can be easily blocked.
INFORMATIVE
REPORTS AND DASHBOARDS
DVS has a magical tool to make comparison, DDL and row-count test in bulk easily.
Graphical representation of data reliability
AUTOMATED
TESTING MECHANISM
Informative dashboards show us the status of data quality of dataware house overall or for a specific time period.
Integrated with ETL tools & BI platforms
Multi Platform
DVS can compare data across different technologies such as Oracle, Microsoft, IBM, SAP and Teradata.
Cross tests amoung different platforms
Data Wizard Tool
Create the most preferred test scripts automatically by using data wizard. DB connections, tables and rules are ready to become a test case.
Ease of use in bulk operations
CONSULTANCY
Never alone against validation problems!
Take the free POC for your firm and learn what effects of DVS on your DWH you never alone against validation problems.
Request a POCFeatures
DATA WIZARD
Create your scripts automatically
Create the most preferred test scripts automatically by using data wizard. DB connections, tables and rules are ready to become a test case.
WEB SERVICES
Connect to remote sources
Integrate with ETL tools using Web Services.
SCHEDULING
Let DVS work for you
You don't need to trigger DVS while you're on your desk. Schedule your suite to make it run anytime and on-time, even you're on a vacation.
LDAP AUTHENTICATION & ROLES
Integrate it with your organization's auth layer
Be secure to give users correct roles -Administrator, Developer, Auditor. Also, you can allow to authenticate single user account only.
IMPORT/ EXPORT
Transfer between repositories
Move a test or suite scripts with all features from one repository to another easily.
ALERT MECHANISM
Stay updated if anything happens
Create alerts, set rules, assign user groups you want to inform in any unwanted situation.
COMPARE MILLIONS OF ROWS
We are not interested in how many rows your database has
DVS algortihms can compare millions of rows in a few minutes.
EASE OF USE
Transfer between repositories
User interface is so friendly. Directions and signs are remarkable.
CUSTOMIZATION
Make it works as you like it
Create conditional test cases. Define primary keys, set you own rules.
Data is the first thing that we need to benefit from BI platforms. You have to know which data should be stored? Data model is healthy or not?
Services
Ask your questions
Data is the first thing that we need to benefit from BI platforms. You have to know which data should be stored? Data model is healthy or not? Also you have to know which data should be historical? What type historical data should be kept? How often data should be updated? Data is coming from different sources. Target data sets are integrated or not? Who knows organization of data? As a result, architecture of DWH should make you use reporting,Olap analysis, data mining efficiently. Is ODS layer necessary? Is metadata layer necessary? What is OLAP?
All above the questions have to be enlightened by the expertise. Zarany is proficient in developing models in regards to sector based Data Warehouse, Datamart, OLAP and Data Mining.
Consultancy and outsourcing.
We can run a number of projects from different sectors.
Consultancy and outsourcing
We know the job!
Zarany has become as an important player in business intelligence area with its in depth comparative experience. We can run a number of projets from different sectors. Also our highest ranking consultants with extensive experience support some projects as an outsource resource in IT departments.
References
TURKIYE IS BANKASI
Is Bank which one of the biggest banks in Turkey, has invested in technology to provide rapid, efficient and top quality solutions to meet the needs of customers.
Since Is Bank wants to be the most preferred, trustworthy, leading bank in Turkey. DVS plays a role after ETL procedures finished in order to assure data quality of Is Bank.
Migros
Migros is one of the top forty largest retail companies in the world. Milllions of sale transactions are done everyday.
DVShelps Migros to achieve an excellent data consistency with a high performance.
VAKIFBANK
Vakıfbank is one of the most preferred and leadings bank in Turkey. They aim to develop customer driven solutions by the means of high qualified DWH.
Vakıfbank choose DVS to achieve the goal of a perfect datawarehouse with valid data.
Request a POC
Give a chance to your DWH team.
Take the free POC for your firm and learn what effects of DVS on your DWH you never alone against validation problems.
Copyright © 2017 Zarany. All Rights Reserved
101 Avenue of the Americas, 9th Floor, New York, NY 10013, USA