Recently, my colleague, Pete Carpenter, described a proof of concept we carried out using Amazon Redshift as the data warehouse storage layer in a system capturing data from Oracle E-Business Suite (EBS) using Attunity CloudBeam in conjunction with Oracle Data Integrator (ODI) for specialised ETL processing and Oracle Business Intelligence (OBI) as the reporting tool.
In this blog I will look at Amazon Redshift and how it compares with a more traditional DW approach using, (more...)
Building an Amazon Redshift Data Warehouse using ODI and Attunity Part 2 : Using ODI and OBIEE with Redshift as a Target/Source
In my post yesterday we stepped through the initial set up and staging load for a data warehouse using Amazon Redshift and Attunity, for eventual use with OBIEE and ODI. Now that we have our source data in Redshift, let’s look at transforming it into a star schema using ODI, by initially looking how we set up the connection to Redshift in ODI’s Topology Navigator.
Building an Amazon Redshift Data Warehouse using ODI and Attunity Part 1 : Configuring Redshift, and CDC Using Attunity
One of our longstanding Oracle customers recently asked us to put together a proof-of-concept DW system using Amazon Redshift as the data warehouse database, rather than Oracle Database. The main driver for this was the economics of running Redshift in the cloud vs. Oracle on-premise, or using Amazon RDS, and they were also interested in the potential performance benefits of running their data warehouse on a column-store database. They were also interested in trying (more...)
The prices for the virtual machines with the Oracle license included run from about USD 820 per month for Oracle Standard Edition (SE) running on 2 cores, to a whopping USD 9300 per month for Oracle Enterprise Edition (EE) running on 8 cores. These prices are for Oracle software only and do not include the cost of the VM, (more...)
I’ve just been comparing a number of online Customer Relationship Management (CRM) systems. In this project, I had the opportunity to sign up to the free trial for various services as well as cancelling these demo accounts.
Modern CRM systems like Highrise, CapsuleCRM, and Batchbook all had a button or a link to cancel or delete an account, with appropriate warnings. But the 800-pound gorilla of CRM, Salesforce, did not. In fact, (more...)
|9h30||Introduction - Actualité Oracle|
Oracle 12c Les nouvelles fonctionnalités• Optimiser vos consolidations de données avec Oracle Multitenant
• Maximiser la disponibilité de vos bases de données
• Automatiser la gestion du cycle de vie de vos informations
Database Innovation : l'innovation au service de vos données• Big Data : comment gérer la croissance de l'information ?
• Database Security : protéger vos information vitales
• Database as (more...)
Pour ceux qui veulent faire un focus sur la mise en place d'infrastructure IaaS et DBaaS avec Oracle Enterprise Manager 12c, voici une lecture qui devrait les intéresser : Managing IaaS and DBaaS Clouds with Oracle Enterprise Manager Cloud Control 12c
- 15 mars : Middleware Management
- 2 avril : Database as a Service