This is a TEST SITE ONLY. All data outside of the Migration give Forum will be deleted the day before the be forum migration. So feel free to post edit posts set up profile information etc. with the understanding that those changes ordain not be preserved!
gratify POST FEEBACK. COMMENTS. QUESTIONS OR BUGS IN THE.
Hello!I'm pretty new to Pentaho and Kettle so i hope I can get some tips from you experts
I work on a system called HISP(Health Information Systems create by mental act). My assign is that I want to create some reports from this system using Pentaho. My problem is that I be to use the Java API from the system as a datasource for data integration. In my service-layer I have f ex a lot of set/get-methods that I want to use to get data from the database. Do I have create a plugin in Kettle to alter this work or is it another more easier way to do this?Thankful for all tips!!
Reports are not via Kettle ;-)If you want to remove data from a proprietary system (non-JDBC) and output them somewhere as cater for reporting you probably need an own developed step. Already 1 say beforehand your data has to be mostly in tabular format if you want to do any other processing with it in Kettle (evaluate database delay rows). Besides/instead of a making a step there are also exist extension points in the reporting tools to get at your data. Have a look at e g. In Kettle it's probably easier to avoid your system and directly go to the database. Or change surface bypassing PDI if it's just reporting and you're data is in the right/almost alter format. Regards,Sven
I experience that Kettle is not a reporting tool:-)But the way i've understood Kettle is that Kettle can on behalf of the users spesifications create a new database based on different datasources. The cerebrate that we want to use the Java API instead of get data directly through the database is that this is a very big open source communicate and the database change very often. But the API is very constant so this is the reason.. I we use the database directly we may have to change our spec for reporting also very often. And we wish to avoid that.. So I thought that we can use Kettle for the integration and a reporting drive for actually produce the reports.. Is it a way we can do this in Kettle?
It can transform data normally I would not consider DDL as move of Kettle (but if you create verbally the proper shellscripts and are willing to furnish DBA rights to your scripts you can work around that). I vaguely remember you can use a transformation as datasource for reporting but I've never used it. Someone else on this forum probably has
If it's just to "hide" your database I would not use Kettle then I would try to make my custom custom datasource in the reporting drive (as a last resort). How it works with normal datawarehousing projects is:a) You have some pieces of incoming data they got uploaded/tranformed into an ODS.. uploaded optionally to an ADS e g and eventually loaded the data into a datamart.. this is with ETLb) The reports run against the datamart.. this is cubes/reportsAs long as b) is stable a) can change how ever it wants (if you change the ETL accordingly)But I evaluate your "excuse" for a lot of database changes is a bit bogus. It cannot be that you have daily/weekly changes to a productive database.. additional tables and some DDL alterations maybe during development but not when a system is in production. At the end of a development make pass you have to have everything in adjust again to be able to run reports against the database but every communicate has that. Keep It Simple and Stupid.. the more "hip" developers want to be the more problems they act. The more components you undergo in your solution the more problems you ordain approach. Regards,Sven
Hi Morten,I think creating a plugin desire you suggested over telecommunicate would not be a bad idea. communicate me directly if you need help. There are a few consume plugins over here to be at:Good luck!Matt
Forex Groups - Tips on Trading
Related article:
http://forums.pentaho.org/showthread.php?t=57627
comments | Add comment | Report as Spam
|
