Recently, at a customer site, I discovered the Attunity connector 1.1 for Oracle. The customer uses this connector to transfer data from Oracle to SQL Server using Integration Services (SSIS) and informed me that performances are greatly improved. So I decided to post a blog about this connector and perform a benchmark between Attunity connector and Microsoft OLE DB provider for Oracle.
Category Archives: Application integration & Middleware
With the appearance of WebLogic Server as Oracle application server and the emergence of the Oracle Fusion Middleware suite, some may wonder what will be the support of their Oracle Internet Application server license, e. g. Oracle Forms and Reports services, Business Intelligence Edition, etc. As a consultant, I am often dealing with these kinds of problems and aiming to improve license benefits. In this post, I want to focus on Oracle Internet Application server licenses.
In this post, I will explain how to install Oracle Fusion Middleware Forms and Reports 11g R2 for a high availability architecture on a Windows platform. For the Linux platform, it’s approximately the same even though the node manager is a daemon.
Last week, Oracle Ace Director Jonathan Lewis held an Oracle Optimizer Workshop at dbi services BaselArea. I would like to share some of the key learnings of this really interesting exchange I experienced together with my colleagues.
Oracle Application Express – APEX 4.1 Introduces many new features such as :
Improved error handling and user-defined exception processing
Application Express now supports the use of ROWID for updates, inserts and deletes as an alternative to specifying primary keys
Developers can now easily add the capability for end-users to load spreadsheet data into existing tables within an application
The calendar wizards have been enhanced to include the ability to create an Edit page as part of creating the calendar
Building on their initial introduction in Release 4.0, the look and feel of Websheets in Release 4.1 has been substantially improved and the controls redesigned to make it more intuitive for users
A complete list of APEX new features can be found on: http://www.oracle.com/technetwork/developer-tools/apex/application-express/apex-41-new-features-459652.html
J’ai eu le plaisir de suivre une formation chez Oracle University à Colombes (Paris). En tant que stagiaire, le cours s’intitulait Oracle Weblogic Administration Essential. Ce post traite de la notion de cluster Weblogic. J’y expose les avantages du clustering weblogic, les principaux éléments à connaître ainsi qu’un exemple de configuration via la console d’administration.
Oracle SQL Developer and Data Modeler are becoming more and more popular as they are both cost-free and available on many Operating Systems (Linux/Unix,Windows and Mac) with different installation types: “This zip does not include JRE” or “This zip file includes the JRE”. On linux, the choice is limited because the only version available doesn’t include Java Runtime Environment. And it’s an RPM !! So what… In this post I will provide all information required to install and run these tools on an Ubuntu machine.
dbi services search and test all tools or functions possible to optimize or to win something to propose the best tuning possible in their client.
The property of Spare columns is not the most used in client environment that we have seen.
This article present a script to find the potential columns that can have the sparse property with the usage restrictions to make a space tuning in your database and especially for Data Warehouse (DWH).
The database example that we used, is AdventureWorksDW2008R2.