I used Cognos Impromptu/Transformer/Powerplay about 8 years ago to develop a data warehouse product for a Universe based ERP vendor and at the time it accessed whatever database you pointed it at via ODBC. Is this not still the case? If so, here are some points to ponder:
1. ODBC is a horrendous resource hog as is the production of cubes via Transformer. Consider a separate reporting server to handle this stuff and take the load off your ERP/transaction system. 2. Break every rule of database design when creating the tables to be accessed via Impromptu. ODBC statements with complex (or even simple really) table joins take forever. Create your reporting tables so that everything is in one table for a reporting area so that if possible your SQL statement for sales info is SELECT * from SALES. I'm talking about having the customer name, address, product description, salesperson name, etc as a field in every record. Not a pointer to another table but the actual text. 3. Learning to set up tables/ODBC access under Unidata is probably much easier and cheaper than purchasing and learning to use an ETL product. Besides, that way you just use a basic program to gather your data from the ERP system and write it all to a single "SALES" (for example) table. Feel free to contact me off list if you want to discuss specifics. Mecki Foerthmann wrote: > 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/ > -- ------------------------------------------------------------------------ Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ------------------------------------------------------------------------ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
