Database Integration
Almost all applications today are database driven. In a sense, database is the heart of the application.
Having a correctly designed and configured database can have a drastic impact on the whole lifecycle of an information system.
We have experience in linking and resolving issues that arise when your projects involve DBMs that are heterogeneous on technical, data model and semantic levels.
Customers are presented with accurate estimates and comprehensive analyses of available options, and often find that we provide them with much
needed insight in addition to pure implementation and technical manpower.
Microsoft SQL & SSIS
We specialize in database development and integration using MS SQL and SSIS (SQL Server Integration Services, updated DTS) technologies. We are also
familiar with other top tools of the trade, including integration solutions by Pervasive and Scribe.
Custom Database Design & Modelling
Whether we will develop the application itself or not, our specialists will help you with the entire design and modelling of database
to meet your business needs. We work closely with the customer to understand their business processes. We then deliver fully qualified Data Model
documents that make positive impact on development effort required for the rest of the application.
Database Review & Optimization
A lot of times existing database driven applications require improvements or modifications to support additional functionality. By reviewing
and testing your database, we will make substantiated recommendations and help implement the changes. We are also happy to step in when customers find that
"throwing more hardware" at the problem will not (or did not) resolve their problem.
Database Maintenance & Infrastructure Services
Not everyone can afford to have a database administrator on their network administration team. This does not mean that your business does not
require a healthy, fast, and reliable database to make sure your line-of-business application is working. We provide implementation
assistance for database high availability, including mirroring with various modes of fail-over, or database clustering.
We can also assist with implementing and training your in-house staff on "house-keeping" tasks like database backups and maintenance plans.