home :: log on ::contact us
Home >>Consulting>>Data Services>>Data Warehouse Integration
search
Data Warehousing and Integration
Requirements Analysis
Choose the right tools that will meet your IT and Business requirements. We use a weighted scale based upon your current and future needs. Some of the evaluation criteria include the following: Vendor viability, Useability, Source and Target systems supported, Cost, Ease of use...et al. We work with you to set up the evaluation criteria and weights, the finalized scores are targeted to your infrastructure and business needs. Pre-created evaluation spreadsheets are available for: General (applicable to all tool categories), ETL, cleansing, Reporting, Metadata, & RDBMS categories. A sample is available for you to view.

View Sample evaluation for 2 general attributes
Tool Evaluation and Recommendation
Gathering requirements takes place in two steps: first, let the users impart to you what they think has importance and second, know the questions to ask.
At Knopman IT, we know the right questions and listen carefully to the business users.
Experience has taught us what the standards are for many industries, we come to the table with successful implementations for Insurance, Banking and retail industries. We customize the solution to meet your particular business needs.

Requirements can either be gathered using spreadsheets and other forms of documentation or using RUP (Rational Unified Process). The vehicle used will be dependent on the type of project and former requirements initiatives if any exist at your location.
Other services Provided
  • Data Modeling - ODS, DW, staging area or extract location
  • Testing - full E2E testing: Parallel, Unit, System Integration, Oversight of UAT
  • Performance Tuning
  • Creation of Methodologies and standards for your installation
  • Thought Leadership
ETL tools
Extraction, Transformation and Load. These tools bear the brunt of your loading capacity and are responsible for historical and batch processes. The market leading tools are: Informatica's Power Center/Mart, Ascential's DataStage & AbInitio. Others well known are Data Integrator, Data Junction & Mercator. At Knopman IT Consulting we specailize in the market leaders but can help you plan and prepare for any other type of translation vehicle.

Services for the market leaders cover:
  • Installation
  • Configuration
  • Performance Tuning
  • Development Standards & Methodologies
  • Technical team leadership
  • Specifications
  • Upgrades
  • Training
The specifications for ETL and Message Brokers are extensions from the requirements gathreing phase. The specs should include; error criteria and actions, default values, source & target identification and business rules, et al .. View a sample specification.

Message Brokers
Message Brokers or Publish/Subscribe services provide Near Real-Time and Real-Time solutions for updates of data warehouses. The market leaders in this tool space that we provide support for are: Web Logic, WebSphere, and Striva.
  • Installation
  • Configuration
  • Performance Tuning
  • Development Standards & Methodologies
  • Technical team leadership
  • Specifications
The same type of specification should be used for MB as the ETL.