tag:blogger.com,1999:blog-4527276399966185267.post5441918370343942441..comments2024-03-06T20:16:30.599-08:00Comments on Diethard Steiner on Business Intelligence: Star Schema Modeling with Pentaho Data IntegrationAnonymoushttp://www.blogger.com/profile/05683544764949933581noreply@blogger.comBlogger40125tag:blogger.com,1999:blog-4527276399966185267.post-18747152183732225142014-02-02T23:54:08.539-08:002014-02-02T23:54:08.539-08:00Good question ... I haven't heard about anythi...Good question ... I haven't heard about anything. The idea/hope was that someone from the community would pick up development. I doubt that Pentaho will develop something similar ... they could have just continued working on this plugin then. If you are a Java developer, you might want to have a look yourself at the source code and maybe you can then add some new functionality.Anonymoushttps://www.blogger.com/profile/05683544764949933581noreply@blogger.comtag:blogger.com,1999:blog-4527276399966185267.post-45413014924049763442014-02-02T16:01:31.177-08:002014-02-02T16:01:31.177-08:00So, did anybody finally continue development con t...So, did anybody finally continue development con this plugin? Is pentaho thinking about developing something similar?Anonymoushttps://www.blogger.com/profile/18189270691621752104noreply@blogger.comtag:blogger.com,1999:blog-4527276399966185267.post-75702283443026110762013-11-25T08:16:22.262-08:002013-11-25T08:16:22.262-08:00Yes, this plugin is unfortunately not maintained a...Yes, this plugin is unfortunately not maintained any more by Pentaho. Now it's down to somebody from the community to continue development on it.Anonymoushttps://www.blogger.com/profile/05683544764949933581noreply@blogger.comtag:blogger.com,1999:blog-4527276399966185267.post-67233584529052496982013-11-25T08:10:47.997-08:002013-11-25T08:10:47.997-08:00Hi, Pentaho website says this plugin is in hold st...Hi, Pentaho website says this plugin is in hold status. Its not available in data integration 5.0.1 build nor in the marketplace. However I did download the zip and install in latest version.<br />while it gives all the errors above...it is still possible to save the file and generate jobs by using 'save as' after closing the error panels.<br />This is a really useful plugin and hope Pentaho incorporates this in future.<br />Thanks.Anonymoushttps://www.blogger.com/profile/16377926349245142202noreply@blogger.comtag:blogger.com,1999:blog-4527276399966185267.post-931896776473227792013-07-16T03:01:56.855-07:002013-07-16T03:01:56.855-07:00Thanks a lot!Thanks a lot!giac_manhttps://www.blogger.com/profile/06190010088493203979noreply@blogger.comtag:blogger.com,1999:blog-4527276399966185267.post-6492353427974311492013-07-15T09:05:32.740-07:002013-07-15T09:05:32.740-07:00Actually, you can find the star modeler in the agi...Actually, you can find the star modeler in the agile bi version of Kettle which you can download from ci.pentaho.org (please note that this is in active development and should not be used for production purposes).Anonymoushttps://www.blogger.com/profile/05683544764949933581noreply@blogger.comtag:blogger.com,1999:blog-4527276399966185267.post-13143640330937901332013-07-15T05:52:01.751-07:002013-07-15T05:52:01.751-07:00The only link I have is the one posted in this blo...The only link I have is the one posted in this blog post. The last thing I heard about the star modeler was that it will be available in version 5 as a plugin via the marketplace and that in future the community will take over the development of the plugin. Maybe you can ask the question in the Pentaho Kettle forum.Anonymoushttps://www.blogger.com/profile/05683544764949933581noreply@blogger.comtag:blogger.com,1999:blog-4527276399966185267.post-47223787118311071222013-07-15T03:48:02.740-07:002013-07-15T03:48:02.740-07:00Hi,
There is already a case in Jiira for this err...Hi,<br /><br />There is already a case in Jiira for this error. Is the one created by KRISHNAMOORTHY. <br /><br />Marketplace is not present in my Pentaho version 4.4.1 - I am not sure I have the latest version of Star Modeler, could you send me a link?<br /><br />Thanks a lot<br /><br />Giacomogiac_manhttps://www.blogger.com/profile/06190010088493203979noreply@blogger.comtag:blogger.com,1999:blog-4527276399966185267.post-14117921392246419562013-07-15T01:32:18.564-07:002013-07-15T01:32:18.564-07:00Thanks a lot for your feedback! In the latest vers...Thanks a lot for your feedback! In the latest versions the Star Modeler is available as a plugin via the marketplace. If you get errors, please submit a jira case on jira.pentaho.org.Anonymoushttps://www.blogger.com/profile/05683544764949933581noreply@blogger.comtag:blogger.com,1999:blog-4527276399966185267.post-53958955923186180022013-07-14T09:55:20.731-07:002013-07-14T09:55:20.731-07:00Hi Diethard,
I am a little bit confused. I have P...Hi Diethard,<br /><br />I am a little bit confused. I have PDI version 4.4.1 installed and you mentioned that the latest version (in 2011) should have the star modeller already included. I can't find it on this version. Am I missing something?<br /><br />I have installed the plug in and everything works until I load the fact table. I got the same error as KRISHNAMOORTHY and then kettle crash.<br /><br />Can anyone help?<br /><br />Many thanks!giac_manhttps://www.blogger.com/profile/06190010088493203979noreply@blogger.comtag:blogger.com,1999:blog-4527276399966185267.post-46289782653920773542013-05-06T12:11:31.396-07:002013-05-06T12:11:31.396-07:00Thanks for your feedback! The latest version you c...Thanks for your feedback! The latest version you can find on ci.pentaho.org ... it's included in the latest PDI ... just note: do not use this version for production purposes!Anonymoushttps://www.blogger.com/profile/05683544764949933581noreply@blogger.comtag:blogger.com,1999:blog-4527276399966185267.post-90772813574335072432013-05-06T01:46:14.729-07:002013-05-06T01:46:14.729-07:00Hello and thanks for this great tutorial. I want t...Hello and thanks for this great tutorial. I want to create a star model but when i download the 4.4.2 version of the PDI it doesn't include the starmodeler plugin and when i install it it gives the NoSuchMethod error which is an unresolved bug. I was wondering when can i get the exact same PDI tha you worked with in this tutorial. Thanks in advance.Nemohttps://www.blogger.com/profile/11262480024544317774noreply@blogger.comtag:blogger.com,1999:blog-4527276399966185267.post-3133193904015649612013-02-24T23:52:04.048-08:002013-02-24T23:52:04.048-08:00Please create a bug report on jira.pentaho.comPlease create a bug report on jira.pentaho.comAnonymoushttps://www.blogger.com/profile/05683544764949933581noreply@blogger.comtag:blogger.com,1999:blog-4527276399966185267.post-30259362300143986442013-02-24T22:44:04.266-08:002013-02-24T22:44:04.266-08:00In Pentaho DI 4.4 , if i try to add fact table usi...In Pentaho DI 4.4 , if i try to add fact table using star model , I am getting the following error continuously..Kindly help me out<br /><br />An unexpected error occurred in Spoon: <br />org.pentaho.metadata.model.LogicalRelationship.(Lorg/pentaho/metadata/model/LogicalTable;Lorg/pentaho/metadata/model/LogicalTable;Lorg/pentaho/metadata/model/LogicalColumn;Lorg/pentaho/metadata/model/LogicalColumn;)V<br />java.lang.NoSuchMethodError: org.pentaho.metadata.model.LogicalRelationship.(Lorg/pentaho/metadata/model/LogicalTable;Lorg/pentaho/metadata/model/LogicalTable;Lorg/pentaho/metadata/model/LogicalColumn;Lorg/pentaho/metadata/model/LogicalColumn;)V<br /> at org.pentaho.di.starmodeler.StarModelDialog.getRelationshipsFromFact(StarModelDialog.java:591)<br /> at org.pentaho.di.starmodeler.StarModelDialog.drawLogicalModel(StarModelDialog.java:645)<br /> at org.pentaho.di.starmodeler.StarModelDialog$6.paintControl(StarModelDialog.java:285)<br /> at org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source)<br /> at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)<br /> at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)<br /> at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)<br /> at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source) KRISHNAMOORTHYhttps://www.blogger.com/profile/13038147656388582785noreply@blogger.comtag:blogger.com,1999:blog-4527276399966185267.post-84129871622383925872012-06-18T00:30:55.194-07:002012-06-18T00:30:55.194-07:00I set up this JIRA case: http://jira.pentaho.com/b...I set up this JIRA case: http://jira.pentaho.com/browse/PDI-8018. Once this issue is solved I can look at your file.Anonymoushttps://www.blogger.com/profile/05683544764949933581noreply@blogger.comtag:blogger.com,1999:blog-4527276399966185267.post-70178259941397801222012-06-18T00:08:21.774-07:002012-06-18T00:08:21.774-07:00Hi Diethard,
I'm working with pdi-ce-4.4.0-M1-...Hi Diethard,<br />I'm working with pdi-ce-4.4.0-M1-r16929 version on Windows7.<br /><br />Thanks!simon03https://www.blogger.com/profile/12044431315699143967noreply@blogger.comtag:blogger.com,1999:blog-4527276399966185267.post-56321084656777570902012-06-17T10:45:54.033-07:002012-06-17T10:45:54.033-07:00Hi Simon,
I tried to open your file in the latest ...Hi Simon,<br />I tried to open your file in the latest PDI version (pdi-ce-4.4.0-M1-r16933) on Ubuntu and everything is blank. I opened your file then in a text editor and can see that there is definitely useful stuff in there. What exact version are you working with (and which OS)? Maybe there are indeed some bugs with the current version of PDI in which case we should set up some JIRA cases on http://jira.pentaho.com/.<br />Best regards,<br />DiethardAnonymoushttps://www.blogger.com/profile/05683544764949933581noreply@blogger.comtag:blogger.com,1999:blog-4527276399966185267.post-86841921015725352792012-06-14T02:11:51.175-07:002012-06-14T02:11:51.175-07:00Thanks, I try to take a look at it in the next few...Thanks, I try to take a look at it in the next few days.Anonymoushttps://www.blogger.com/profile/05683544764949933581noreply@blogger.comtag:blogger.com,1999:blog-4527276399966185267.post-35750289873591769302012-06-14T02:02:51.822-07:002012-06-14T02:02:51.822-07:00Ok! I've shared the star model file at this li...Ok! I've shared the star model file at this link:<br />https://docs.google.com/open?id=0B13bSoiYs-qKeHd1N0ZuaVEwaFU<br /><br />Thank you!simon03https://www.blogger.com/profile/12044431315699143967noreply@blogger.comtag:blogger.com,1999:blog-4527276399966185267.post-81892900326431226252012-06-14T01:28:54.057-07:002012-06-14T01:28:54.057-07:00I can try to have a look at your file - no promise...I can try to have a look at your file - no promises, I don't know yet when I will find time. Can you make it available online somewhere (Google Drive, Dropbox, etc)?Anonymoushttps://www.blogger.com/profile/05683544764949933581noreply@blogger.comtag:blogger.com,1999:blog-4527276399966185267.post-79680694241386753622012-06-14T01:19:45.092-07:002012-06-14T01:19:45.092-07:00Hi Diethard! thank you for this tutorial!
I'm ...Hi Diethard! thank you for this tutorial!<br />I'm working with 4.4 version but I have a problem when I try to "Generate transformations" (the user interface in 4.4 is a little different, I think that is the same action of the "Domain job" button in this tutorial).<br />The error that occurred is:<br /><br />org.pentaho.di.core.exception.KettleXMLException: <br />Error reading information from input stream<br />InputStream cannot be null<br /><br /> at org.pentaho.di.core.xml.XMLHandler.loadXMLFile(XMLHandler.java:588)<br /> at org.pentaho.di.trans.TransMeta.(TransMeta.java:2387)<br /> at org.pentaho.di.starmodeler.generator.JobGenerator.generateDateTransformation(JobGenerator.java:390)<br /> at org.pentaho.di.starmodeler.generator.JobGenerator.generateDimensionTransformations(JobGenerator.java:368)<br /> at org.pentaho.di.starmodeler.StarModelerPerspective.generateDomainJobButton(StarModelerPerspective.java:734)<br /> at org.pentaho.di.starmodeler.StarModelerPerspective$11.widgetSelected(StarModelerPerspective.java:631)<br /> at org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source)<br /> at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)<br /> at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)<br /> at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)<br /> at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)<br /> at org.pentaho.di.ui.spoon.Spoon.readAndDispatch(Spoon.java:1186)<br /> at org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:7031)<br /> at org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:580)<br /> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)<br /> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)<br /> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)<br /> at java.lang.reflect.Method.invoke(Method.java:597)<br /> at org.pentaho.commons.launcher.Launcher.main(Launcher.java:134)<br />Caused by: java.lang.IllegalArgumentException: InputStream cannot be null<br /> at javax.xml.parsers.DocumentBuilder.parse(DocumentBuilder.java:120)<br /> at org.pentaho.di.core.xml.XMLHandler.loadXMLFile(XMLHandler.java:561)<br /> ... 18 more<br /><br />I double cecked every step but I can't find out the mistake.<br />Thanks!simon03https://www.blogger.com/profile/12044431315699143967noreply@blogger.comtag:blogger.com,1999:blog-4527276399966185267.post-62362717378224717392012-05-31T06:35:17.954-07:002012-05-31T06:35:17.954-07:00Good news! Maybe it was just a Kettle bug which go...Good news! Maybe it was just a Kettle bug which got ironed out with version 4.4. When I initially wrote this tutorial the plugin was only released for testing ... since then there have been several revisions.Anonymoushttps://www.blogger.com/profile/05683544764949933581noreply@blogger.comtag:blogger.com,1999:blog-4527276399966185267.post-39812560611320538512012-05-31T06:29:57.029-07:002012-05-31T06:29:57.029-07:00Thanks a lot.
With 4.4 it runs without any problem...Thanks a lot.<br />With 4.4 it runs without any problems. <br />Would be interesting where my mistake was...Anonymoushttps://www.blogger.com/profile/00230672815918073588noreply@blogger.comtag:blogger.com,1999:blog-4527276399966185267.post-539249952112121302012-05-30T08:24:25.414-07:002012-05-30T08:24:25.414-07:00I just checked and the link above goes to sourcefo...I just checked and the link above goes to sourceforge which has Kettle 4.3 stable. If you want the latest version - note: not to be used in production! - you can get it from ci.pentaho.org.Anonymoushttps://www.blogger.com/profile/05683544764949933581noreply@blogger.comtag:blogger.com,1999:blog-4527276399966185267.post-61166368812809868672012-05-30T08:10:56.703-07:002012-05-30T08:10:56.703-07:00Thanks for reply.
Your link above is still going t...Thanks for reply.<br />Your link above is still going to the latest available version 4.2.1.<br />You know where to find 4.4?Anonymoushttps://www.blogger.com/profile/00230672815918073588noreply@blogger.com