I demoed Epiror's variant of this product, and found that is does indeed look quite nice, but it still is a batch update / scheduled update tool.
Therefore myself and a few friends went forward with building something that can perform transactional updates using triggers, BCI and ODBC client drivers. My requirement was to feed SQL server to enable the use of the Microsoft Analysis Services and Reporting Services on large volumes of data. The side effect to our approach was the "reporting load" is non existent on the U2 server now since the updates are in real time. Bulk re-loading was not acceptable for 10M records. (And other tables that are at or around 1-3M records) -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mecki Foerthmann Sent: Thursday, May 08, 2008 3:07 AM To: [email protected] Subject: [U2] Using ETL to extract data from UD to SQL Hi group, have any of you had any experience using ETL from Sybase? The company I work for has bought Cognos for reporting and data mining purposes on their other non-mv applications, and I have given the task (and I told them, it should be possible) to make this work with our UniData ERP application as well. Now I've heard of this ETL product from Sybase that looks pretty simple to use (drag-and drop) and is supposedly very fast since it doesn't use ODBC but UniObjects. So the question is, 'have any of you used it, and if yes, is it any good?' Or do you have any recommendations, which mv-to-sql bridges are worthwhile using. This setting up schemas and sql-tables in UniData (we're still on 5.2) seems to be way over my head, and I don't seem to be getting anywhere that way. many thanks in advance Mecki Foerthmann ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
