Release of Data Moving Tool 2.0

We’re pleased to announce the release of Data Moving Tool version 2.0, packed with enhancement, new functionalities and bug fixes.

Data Moving Tool (DMT) is an easy to use ETL application to Extract, Transform and Load Data to and from any data source (databases and/or flat files).

New Feature: Send Emails automatically
The main new feature in version 2 is the ability to send emails automatically. You can now send emails automatically to inform anyone that an export or load is about to start or has completed. You can use Run Variables in the Email body and title to indicate the name of the group or job, it’s type, the start and end time, the execution result, etc. Emails can be customised separately for each group and job.

Other Enhancements
There are a lot of other enhancements in version 2. For instance DMT now automatically checks for Application Updates at startup so you’re always up to date with the latest available version.
The User Interface has also been improved with new icons, an improved Run Progress Form, and watermarks (explanation text) on text fields.
Run Variables can now be used in many more places throughout the application: Pre and Post Process Email and Command Line, Run Pre-Conditions and Load Conditions.

There are many more improvements to discover in version 2…
Click here to download it.

For more information, visit www.sersoftware.com

Tags: , , , , , ,

How to load data easily from Excel into Oracle?

Oracle is the most widely used database on the planet, so chances are that at some point, you had to load data from Excel into Oracle. I know I had to do it many times and to my surprise, the steps involved were not so straightforward.

In this article I will describe a few “traditional” ways to load data from Excel into Oracle, and show you one that’s much more straightforward. › Continue reading…

You can now buy DMT online!

We’re very pleased to announce that Data Moving Tool can now be purchased online from our website www.sersoftware.com.

We’ve chosen FastSpring for our payment processing to offer you security and ease of payment. FastSpring is a Secure and Reliable industry leader. They offer multiple payment methods and use industry standard SSL to encrypt communications, ensuring your transactions are secure and confidential.

Tags: ,

The Goal

In this article I will describe an easy way to migrate data from one database to another. Source and the target databases (where to extract the data from and where to load the data into) don’t need to be from the same vendor.

In fact they could be any combination you could possibly thing of e.g. Oracle, SQL server, MySQL, from MS Access, Sybase, DB2, etc.
› Continue reading…

Tags: , , , ,

A better reusable menu code with PHP and CSS

I recently posted an article on how to create reusable menus for a website with php and CSS. Although it’s a perfectly valid method to create reusable menus, I couldn’t help but being unsatisfied with the use of global variables and the include of one file per menu.

So I decided to find a better way, and this is what I’m going to show you here today. The idea is to get rid of the global variable and the include and instead pass a parameter to a function.
› Continue reading…

Tags: , , , ,

Reusable menu code with PHP and CSS

In this article I will show you how to create menus for a website and how to reuse the same menu code in all your pages, making your menu display on each page with only 2 lines of code.

You can see these menus in action on my website www.sersoftware.com. I use the same technique for horizontal and vertical menus.

Note: Since I wrote this post, I’ve enhanced the code to a more efficient version. You can find these enhancements in the post “A better reusable menu code with PHP and CSS“.
› Continue reading…

Tags: , , , ,

How DMT came about

So that’s it, after all together about 3 years working on and off on the DMT project, version 1.0 of the Data Moving Tool is finally out (check its features here and download it here). Here’s a brief flashback on how the idea came about.
› Continue reading…

Tags: , , , , , , , , ,

Release of Data Moving Tool 1.1.2

We’re pleased to announce the release of Data Moving Tool version 1.1.2, packed with enhancement, new functionalities and bug fixes.

Click here to download it.
Click here to find out what’s new in version 1.1.2.

For more information, visit www.sersoftware.com

Tags: , , , , ,
Back to top