databasejournal.com databasejournal.com

The Old and New of Oracle Business Intelligence

In the world of Business Intelligence, the day has arrived. Oracle recently announced the release of Oracle Business Intelligence 11g, and the goods are now available. Steve Callan provides a history, tracing the software back to its origins, comparing the 10g with the 11g version. In the world of Business Intelligence, the day has arrived. Oracle recently announced the release of Oracle Business Intelligence 11g, and the goods...

databasejournal.com databasejournal.com

What's New in Oracle Warehouse Builder

Oracle Warehouse Builder (OWB) has seen many changes lately. Keeping up with new features in the Oracle RDBMS can be challenging enough, but when you add changes to products, you may have your work cut out for you. This article explores some updates in OWB for Oracle11gR2 (plus some of the changes between 10g and 11g). Starting with 11gR1, OWB users work in a workspace as opposed to having their own repository schemas as found in...

databasejournal.com databasejournal.com

Installing Oracle Database Sample Schemas using Data Pump

Having a re-usable dump file for installing Oracle Database Sample Schemas is much more convenient than the current method. Would you rather download a compressed file containing one (or several) dump files, including a parameter file suitable for use during an import session or job or use the Oracle Universal Installer? I wrote an introductory article a few years ago (actually more like six) about the new Oracle Database Sample...

databasejournal.com databasejournal.com

Mapping SQL Server Management Features to Oracle Database

DBAs often need to learn where features of their system can be found on other systems. Steve Callan explores mapping SQL Server replication and management features back into Oracle Database. Oracle as a Data Source, Setting up Oracle as a Data Source for SQL Server and Configuring Oracle as a Data Source for SQL Server address the use of replication within SQL Server where Oracle was used as the data source, and many of the...