Here what is new is coming in 2017

We a working on extending functionality of Enterprise version by creating monitors

Monitor is a constantly running background process waiting for an event to happen.

For example directory monitor is waiting for a new file to arrive. Once file is here it executes predefined package or transformation.

Planned Monitors:

  1. Directory Monitor
  2. Email Monitor
  3. FTP Monitor
  4. MMQ Monitor
  5. HTTP Monitor
Running 64 bit and 32 bit packages.

Scheduler will be extended so it would possible to say which Architecture to use 32bit or 64bit. Same apply to the log viewer.

Repository modifications.

Repository structure would be modified to accommodate the changes above.

Management console will be extended as well.
Repository connections

We will switch from using OleDB to direct connections to the repository database. This will make using MySQL, PostgreSQL and Interbase/Firebird as repository much easier. We will add support for SQLite as repository and make it default.

Repository backup

Currently it is slow for large databases. There is a way to make up to 10 times faster.

Performance

There is a potential to increase performance of update/delete transformations by up 2 times  for some data targets.

Documentation

There is no such thing a perfect documentation so we will continue working on

As usual your feedback and suggestions are welcome please post them here:
http://www.etl-tools.com/forum/index.html

We have added the following fields to AD user data extract:

  • displayName
  • distinguisedName
  • initials
  • mailNickname
  • publicDelegates
  • sAMAccountType
  • scriptPath
  • showInAddressBook
  • sn

ExtractingDataFromActiveDirectory

This update apply to both Visual Importer ETL and Advanced ETL Processor

I the latest release  of our ETL Software we have made FTP directory list  the same for SFTP and FTP servers

The format is:

  • Permissions
  • File Size (if present)
  • File Modification Date (if present)
  • File/Directory Name

File is tab delimited with no headers

Here is small and useful tip:

you can how generate table creation script by simply clicking on the data

GenerateTableCreatingScript1

GenerateTableCreatingScript2

And here is the sql script:

create table TableName (
[COMPANY NAME] CHAR(29),
[YEAR] CHAR(10),
[MONTHID] CHAR(9),
[PRODUCT ID] CHAR(12),
[AMOUNT] CHAR(12))

It is not ideal but it is a very good start

This update apply to both Visual Importer ETL and Advanced ETL Processor

 

Customer Loyalty Programs

 

A Free License for IT Professionals

Send us a link to your profile and get a free license for any ETL product!

suit up
Promote our ETL Software

You can get a significant discount, and even a free license, by spreading a word about our ETL Software.

chat
Competitive Upgrades

Get 50% OFF for switching to our ETL Software from competing tools!

money

Go to top