Donald Sallot
"Technology for a Purpose"

Home

 

Overview
ETL Development
DW Consulting
DW Training

 

Education Institution Information Reporting Solution

Our Information Reporting Portal service provides educational institutions with the reports that are need on a daily basis. 

We have built an ODS (Operational Data Store) specifically for Datatel® Colleague® ERP system. You provide data extracts, and we manage your information by loading the information into our proprietary reporting mart. Our service is to provide an information reporting architecture that interfaces with Datatel® Colleague® Application Suite. 

Our process is simple, you supply the data we turn it into information and send it back or provide access to it.

We understand that there is limited staffing, budget and time to fully implement with your staff an integrated reporting architecture. 

We have been successfully implementing a Reporting Architecture (ODS) for a college in California and we would like to make our capabilities available other users as well. 

For a small subscription fee and monthly service charge we provide: 

  • We work with you staff on building the exports from Colleague®
  • We provide a pre-design ODS reporting architecture on our servers
  • We provide all of the programming and database info-structure to cleanse and transform your data into valuable information at our site.
  • We provide the connectivity to send to your institution the result set that can be loaded into your database.
  • We provide custom information views that are not available out of the box.
Data Stage ETL Development and Conversions Services
 

Our data stage development and conversion service allows your company to have the benefit of additional ETL development resources without requiring a long term employee commitment. Our experience includes the 7.5.x release and before, including parallel extender. We can provide the ETL Data Acquisition Design, Source System Analysis, Source to target mappings and Data Stage ETL development and testing.
 

Data Warehouse Development and Implementation Consulting Services
 
Your business depends on its data warehouse to deliver the right data to the right people at the right time so they can use it to make critical business decisions.
 
We have over 10 years of successful data warehouse and implementation experience.
 
Data Warehouse Development Methodology Training
 

Over 10 years of successful data warehouse methodology and project development and planning experience.

This 3 day course is fast paced and will provide a solid foundation for companies wishing to implement a new or refine their exiting data warehouse program. Significant level of detail in defining a data acquisition / information delivery data warehouse architecture. Course is designed to meet the various software / hardware platform environments, such as: Oracle, DB2, UDB, SQL Server, ERP Data Sources, ETL Tools and BI Tools. 

 

Send mail to info@oceansoftware.com with questions or comments about this web site.
Copyright © 2006 Donald Sallot
Last modified: 05/25/07