SQL Server

Planning And Executing A Successful SQL Server Database Migration

By | White Papers | No Comments

By Carlos Colon / DBA Manager at Dobler Consulting

Migrating an existing database to SQL Server can be a taunting task. No matter if your current database is Oracle, Sybase, DB2 or MySQL, the core of the migration tasks are almost always identical. A SQL Server database migration project can be broken down into 6 steps.

1. Analysis
2. Planning
3. Build
4. Migrate, Test, Fix, Repeat
5. Deployment
6. Support

This presentation will walk you through these steps and in addition will also cover these topics:

– Typical SQL Server Migration Plan
– Key Deliverables
– Database Migration Steps
– Brief Overview of SQL Server Migration Assistant Tool (SSMA)
– Common Problems in Database Migrations

Download the Guide For FREE!!

Read More

mPOS – An enriched retail experience for merchant as well as customer

By | White Papers | No Comments

Mobile point-of-sale is transforming the retail industry with new technology. For small merchants, the benefits of installing mPOS technology are low-cost card acceptance on smartphones and tablets along with access to other retail management tools. For large retailers, mPOS provides a way to improve customer service.

Read More

Beacons – An endless opportunity for brands on proximity based solution & customer engagement

By | White Papers | No Comments

Today all consumer brands are facing the same challenge —shoppers have so many choices, with the competition always just a few keystrokes away, any time of the day or night. Its not only the price. Serbia has become the key differentiator. To earn a sale and repeat visits, brands need to deliver the very best in service, every time a shopper walks through the door. The focus is now on keeping the consumer engaged. Bean technology can make that happen — automatically. Beacons has the potential in building some very personalized experience for the end users in various business verticals e.g. Restaurants & Food Chains, In Retail Stores, Malls, Stadiums, Events, Museums, Airports & Metro Rail Systems, Retail Banking, Educational Institutions, Hospitality. This white paper introduces brands in the power of beans. It describes the business and technical aspects of bones.

Download the white paper here:

Read More

The Jamcracker Platform – Cloud Services Governance and Management for the Enterprise

By | White Papers | No Comments

Enterprise cloud computing has transformed IT. Cloud computing decreases time- to-market, improves agility by allowing businesses to adapt quickly to changing market demands, and, ultimately, drives down costs.The ease of deploying and scaling cloud services, along with their relatively low cost of acquisition, has resulted in increasingly decentralized IT, or what is referred to as “shadow IT.”

 

Download the white paper here:

Read More

Usability Comparison White Paper: Informatica vs. Ab initio

By | White Papers | No Comments

This report is an evaluation of two leading Extract, Transform and Load (ETL) tools, Informatica and Ab initio. In spite of long history of data ware housing, business intelligence and data integration industry, it is not an easy to decide which ETL tool is best suited for the organization needs as both Ab initio and Informatica offers a complete ETL solution and both are leaders in the Market.
The purpose of this usability study is to evaluate usability of each solution with respect to various criteria like cost, modularity to support seamless integration with other applications/tools, analytical reporting performance needs, volume and variety of data, loading performance, scalability, ease of use, self-sufficiency, simplicity, compatibility etc. If cost is not a concern Ab initio can be preferred for performance, processing of high volume of data and easy to develop perspective. Informatica provides a broad range of Data Integration products like Informatica PowerCenter, Informatica Data Integrator Hub, Informatica Cloud etc. and hence it boasts of a broader data integration capability. Specific offerings, future scope, ongoing enhancements, data integration capabilities, hardware and operating system requirements, architectural differences, maturity in various market segments etc. are detailed for both solutions.

Download the White Paper for FREE!!

Read More

Using Oracle’s DBMS_APPLICATION_INFO built-in package

By | Oracle, White Papers | No Comments

This document aims at showcasing the capabilities and usage of Oracle’s DBMS_APPLICATION_INFO built-in package. One very important use is to monitor the progress of loops to know exactly which record is being processed at a given moment.

Download the White Paper for FREE!!

Read More

SAP Sybase Replication Server 15.6 | Real Time Loading into SAP Sybase IQ

By | White Papers | No Comments

SAP Sybase has developed a new, innovative and dynamic staging technology, allowing full use of the native, high-speed data load mechanism SAP Sybase IQ offers . . . Real Time Loading (RTL).

RTL addresses the need to have another system prepare the data for load by taking real time data movement from the source database, and applying staging technology to the data transfer in the background.

Up until now, the only option for loading data from an Online Transaction Processing (OLTP) database . . . airline reservation systems, financial transactions, etc., into a SAP Sybase IQ data warehouse was a so-called staging process. Staging means that the OLTP is isolated from the data warehouse loading process to ensure data integrity, due to the rapidly changing data content in the OLTP database systems.

Direct replication into SAP Sybase IQ was limited to low data movement environments. The reason lies in the fundamental differences on how SAP Sybase IQ processes data, and data movement strategies SAP Sybase Replication Server applies.

SAP Sybase IQ is a column vector database. Retrieving a single row requires assembling the row from each column component. This process makes row by row processing ineffective, and the so- called “trickle feed” loading of SAP Sybase IQ nearly impossible. The advantage of a column vector database is in the unmatched speed for complex data retrieval operations and data aggregation on huge data sets.

Download the White Paper for FREE!!

Read More

Oracle To SAP Sybase ASE Migration Guide

By | White Papers | No Comments

The Oracle to SAP Sybase Migration Guide provides detailed information on migrating a database from Oracle® 9i, 10g and 11g to Sybase Adaptive Server® Enterprise (ASE). The processes and differences outlined in this guide will help you to manage the migration process, regardless the conversion tool you are using to perform the migration. The focus is on the Oracle to Sybase ASE migration and Oracle features like data replication or data warehousing are better utilized in other specialized Sybase products.

If not otherwise specified all stand-alone references to simply Sybase ASE or Adaptive Server are considered references to Sybase Adaptive Server® Enterprise.

Download the Guide For FREE!!

Read More

%d bloggers like this: