Oracle and MySQL Loader Review

New Version 3.0 Released

Data Loader is a powerful tool designed to make importing and exporting data between various formats a breeze. The latest version, 3.0, comes packed with new features and enhancements that make data manipulation even easier than before.

New Features in Version 3.0

• Folder Polling: Data Loader now has the capability to watch for files in a specified folder at intervals and automatically load data from filenames that match a specified pattern into tables.
• Support for MS-Access 2007 and MS-SQL Server Express Edition: This version includes support for newer versions of MS-Access and SQL Server, giving users more flexibility in their data loading processes.
• Progress Monitoring: Users can now track the progress of their data loading sessions in real-time, making it easier to monitor and manage large data transfers.
• Many Other Enhancements: Version 3.0 also includes various other improvements and enhancements to make the data loading process more efficient and user-friendly.

New Features added in Version 2.5

• Load data in MySQL databases hosted on Shared Web Hosting: This feature allows users to easily load data into MySQL databases hosted on shared web hosting platforms, opening up new possibilities for data migration.
• Custom Destination Table Names: Users now have the ability to change and choose the destination table names when loading data, giving them more control over the data loading process.
• Load from Multiple Delimited Flat Files: Version 2.5 allows users to load data from multiple delimited flat files into multiple tables in a single session, saving time and streamlining the data loading process.
• Enhanced Column Mapping: The column mapping feature has been further enhanced in this version, making it easier to map columns between different databases and formats.
• Support for Microsoft SQL Server: Users can now load data into Microsoft SQL Server databases using Data Loader, expanding the tool’s compatibility with different database systems.
• Transformation Support: Data Loader now supports data transformation through the use of views, allowing users to manipulate and transform data during the loading process.

Data Loader Scheduler

One of the standout features of Data Loader is its built-in scheduler, which eliminates the need to run data loading jobs repeatedly. Users can simply start a session, define the schedule date and time, and Data Loader will automatically execute the session in the background, recording all actions in a specified logfile.

With its support for a wide range of database formats, including MySQL, Oracle, MS Access, FoxPro, DBF’s MS SQL Server, CSV, and delimited or flat files, Data Loader is a versatile tool that caters to the diverse data loading needs of users. Whether you are looking to transfer data between different databases, apply filters, or specify WHERE conditions, Data Loader offers a simple and efficient solution for all your data loading requirements.

Overall, Data Loader is a reliable and feature-rich tool that simplifies the process of importing and exporting data, making it a valuable asset for businesses and individuals alike. With its latest updates and enhancements, Data Loader continues to set the standard for data loading tools in the market.

Folder Polling | MS-Access | Data Transfers | Data Manipulation | MySQL | Loader | Review | Database Formats | Filters | Transformation Support | Microsoft SQL Server | Shared Web Hosting | Exporting | MySQL Databases | Oracle | Data Loader | Progress Monitoring | Data Loader Scheduler | MS-SQL Server Express Edition | Custom Destination Table Names | Importing | Column Mapping | WHERE Conditions | Version 3.0 | Data Loading Tools