ETL and Data Integration tools - Modern ETL software for everyone

Hi.

I would like to use your product (Visual Importer Enterprise), to export data from an MS SQL server to an Oracle machine whenever new data is imported in MS SQL.
Is there some way of doing this?
I have no way of identifying what data is new, as there is no date field, so I can't create a procedure to do this extraction for me by selecting data by date inserted.
If a trigger type function is not available, can you suggest some type of functionality in your product?

Luc

Luc

Assuming that your table has a primary key and there are no updates only inserts
You can do the following
on oracle site
select max(pk_field) from the table
save value into variable
than when pooling the data from sql server
use select * from table where pk_field>

We can create for you a flash tutorial if you wish

Mike,
DB Software Laboratory

Hello Mike,

Thanks for your quick response. I would very much appreciate a flash tutorial to see what VI can do out of the box. I would prefer the possibility of updates being handled as well, but I may create a new trigger on the database to insert on a new table to cover this need.

Thanks again
Luc

Luc

It is possible to do updates as well
The best solution would be to add field last_modification field to source table
We are working on the tutorial now

Mike

Thank you Mike. much appreciated.

www.dbsoftlab.com/images/Screenshots/Fla...o_update_records.htm

Here it is
Hope that what you wanted
Mike