Infrastructure at your Service

Category Archives: Application integration & Middleware

Yann Neuhaus

SQL Server: Attunity connectors for data transfer to Oracle

By | Application integration & Middleware | 3 Comments

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.

Read More
Arnaud Berbier

Upgrading your Oracle Internet Application Server license

By | Application integration & Middleware | No Comments

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.

Read More
Grégory Steulet

Oracle Application Express (APEX) 4.1: a migration guide

By | Application integration & Middleware | 5 Comments


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:

Read More
Arnaud Berbier

Oracle WebLogic Essentials : avantages du clustering

By | Application integration & Middleware | 4 Comments

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.

Read More
Jérôme Witt

Oracle SQL Developer & SQL Data Modeler on Ubuntu

By | Application integration & Middleware | No Comments

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.


Read More
Stéphane Haby

SQL Server Tuning: Detect SPARSE columns candidate

By | Application integration & Middleware | 6 Comments

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.

Read More