ONEDB | Solutions Technology Limited

On-Premise

Despite current trends towards cloud solutions, by this approach, business can achieve the same benefits. On-premise environment increases the power for maintenance and flexibility for tuning and performance enhancement.

Cloud and Hybrid

One of the most popular solutions right now is migrating to cloud architecture, it has been a good solution in terms of reducing costs. Depends on the company, a hybrid architecture can make the core databases more flexible in On-Premise while reducing cost in Cloud.

Architecture Services

High investment in hardware and technology are relevant, but enought to avoid your company stops. As less a high availability has been implemented in a cluster or similar solution for an automatic recovering.

Data warehouse development following Kimball methodology including all the dimensions and fact tables. Data stage and ETL in SSIS for better visualisation and maintenance.

Database architecture for reporting is relevant to increase the performance reducing troubleshooting in OLTP production environments.

A hybrid solution can work with On-Premiss and Cloud architectures, making possible high availability while geographic data distribution.

The most Recent Architecture Services

Projects (in Progress)

#	Name	Technology	Description
1	Sales Consultant Tracking	Data Mart Architecture for Tableau	Data analysis for individual and manager sales comission.
2	Demand	SQL 2016 with R Studio architecture	Data analysis to find the demanding products
3	24x7 Database Administration	SQL 2016 Enterprise version, real-time monitoring in Power BI	Database administration and monitoring for all the environments.
3	V8 Car Monitoring	OBDII reading and SQL Azure Cloud architecture	Real-time data reading in OBDII storaging in Azure.

The most Recent Projects (completed)

#	Name	Technology	Description
1	SQL 2016 Cluster	SQL active x active MS Cluster	Covering all the core databases and applications.
2	Report Server	Logshipping for replication in SQL 2016	Redundant database for data warehouse loading and reporting.
3	SQL 2012 to 2016 Migration	Always On, CLuster	Migrated all the database servers.
4	SSRS Migration	SQL 2008 and 2012 to 2016	Migrated to standard and enterprise environments.
5	SQL Instance Consolidation	SQL 2005, 2008 and 2012 to 2016	Consolidated from multiple instances to an unified instance.
6	Generator	MySQL, MS SQL	Data conversion from MySQL to MSSQL from a legacy application.

DATABASE ARCHITECTURE