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.
Scheduler will be extended so it would possible to say which Architecture to use 32bit or 64bit. Same apply to the log viewer.
Repository structure would be modified to accommodate the changes above.
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.
Currently it is slow for large databases. There is a way to make up to 10 times faster.
There is a potential to increase performance of update/delete transformations by up 2 times for some data targets.
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:
you can how generate table creation script by simply clicking on the data
And here is the sql script:
create table TableName (
[COMPANY NAME] CHAR(29),
[PRODUCT ID] CHAR(12),
It is not ideal but it is a very good start