Blog

A CEO’s Guide to Amazon Web Services

Amazon Web Services (AWS) allows you to add and remove computing services on demand. You pay for only what you use.

Solid ODI Review at BI Quotient

If you haven’t had a need for utilizing Oracle Data Integrator (ODI) as an ETL (or E-LT) source as ODI advertises itself then you wouldn’t know that it is actually somewhat of a beast of a ETL tool.

Recovering a Schema From InnoDB .frm Files

Sometimes you find yourself in a bad situation where your only hope of recovering your InnoDB data lies in a handful of .frm and .ibd data files that were heretofore part of a working MySQL installation.

7.9.6.x OBI Apps/DAC Support Patch 8760212 – Just Do It!

Yes, but continue your dubious disposition when discussing the DAC’s daunting developmental digressions and discomforts directly doubling your distress. Make up and continue to play nice.

Oracle User Privileges Scan

I had been looking for a really quick way to diagnose the roles and privileges of users that I created in a test database.

Oracle Backups to S3

Backup your Oracle Database on Amazon S3. The Oracle Secure Backup Cloud Module delivers Oracle RMAN integration with Amazon S3 using an SBT library specific to Amazon S3.

Oracle Licensing on EC2

When it comes to licensing Oracle Databases on Amazon EC2, EC2 pricing does not include Oracle licensing fees, even when using an Oracle-supplied AMI.

Oracle Certification vs Oracle Support

At Collaborate this week, I received a lot of questions regarding support and certification for Oracle on Amazon Web Services.

How Incompetence Stimulates the Information Technology Economy

As information technology professionals, we constantly complain about mismanaged projects in which we have the misfortune to be involved.

Salesforce.com and OBIEE Integration

I’ve been integrating SalesForce.com with OBIEE and some other data warehousing projects for clients for some time now and had a moment to throw this tutorial together.

OBIEE iBots & OBI Caching Strategy with Seeding Cache

Now when your executives arrive at 8am the dashboard will fire-up immediately as it will hit the cache and not need do a full retrieval against the source.

Requirements Gathering & Change Management Techniques

I think two of the most under-appreciated parts of a Business Intelligence and Data Warehousing project are gathering the project requirements and creating the action plan of implementing the solution.