tag:blogger.com,1999:blog-15319370.post5145728240672569757..comments2024-03-05T11:16:00.846+01:00Comments on Roland Bouman's blog: Performing administrative tasks on Pentaho 5.x Business Analytics Server using RESTful webservices and PHP/cURLrpboumanhttp://www.blogger.com/profile/13365137747952711328noreply@blogger.comBlogger19125tag:blogger.com,1999:blog-15319370.post-61803877688977418192017-11-29T18:31:50.587+01:002017-11-29T18:31:50.587+01:00Hi Anonymous,
sure, you can mail me at roland.bou...Hi Anonymous,<br /><br />sure, you can mail me at roland.bouman@gmail.com.rpboumanhttps://www.blogger.com/profile/13365137747952711328noreply@blogger.comtag:blogger.com,1999:blog-15319370.post-1059860732546213872017-11-29T17:16:12.840+01:002017-11-29T17:16:12.840+01:00Thank you for your prompt reply. My first choice w...Thank you for your prompt reply. My first choice was Java but the project requirement is to expose Pentaho Job/ transformation as web service through web assembly. Can I reach you at gmail?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-15319370.post-70526538639945730222017-11-29T00:33:18.908+01:002017-11-29T00:33:18.908+01:00@Anonymous, thank you for your interest.
> I ...@Anonymous, thank you for your interest. <br /><br />> I would like to know whether I can use C as my programming language to create custom applications to interact with Pentaho data?<br /><br />Well, Pentaho itself is a BI suite - it doesn't "have" data, it works with data. In some cases, Pentaho exposes data of source systems it is connected to using its own services, and you can consume these with any webclient. <br /><br />So, in theory the answer is yes. Whether it is practical for the kind of application you have in mind is something that you'll need to investigate. Perhaps the kind of application already exists, or important parts of the functionality you require may be provided by the pentaho platform. If that is the case, then you might be better of sticking to Java since that is the language used to create Pentaho.<br /><br />HTHrpboumanhttps://www.blogger.com/profile/13365137747952711328noreply@blogger.comtag:blogger.com,1999:blog-15319370.post-32273812384180774802017-11-28T23:36:09.185+01:002017-11-28T23:36:09.185+01:00Hi Roland, I am new to Pentaho and I would like to...Hi Roland, I am new to Pentaho and I would like to know whether I can use C as my programming language to create custom applications to interact with Pentaho data?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-15319370.post-49943779154686725902017-05-18T14:41:43.152+02:002017-05-18T14:41:43.152+02:00Just a note for anyone playing with user creation ...Just a note for anyone playing with user creation through the API - if you manage to somehow create an empty user (I did that while testing, accidentally of course), you cannot manage them through Pentaho console any more, as the whole "Manage Users" tab just disappears. <br /><br />To make things a little worse, you cannot delete this empty user through the API so you get pretty stucked (I didn't find a way to delete them since the users are saved in jackrabbit repository which is a "black hole" to me).<br /><br />And to make things a little bit more worse, if you happened to create user in Pentaho console, but forgot his password (stupid me), no probllem - you can delete it and recreate it through the API (blessed roland) but you still won't be able to login (wrong password) so forget about it and create another one :-)Dejanhttps://www.blogger.com/profile/00263648484184792884noreply@blogger.comtag:blogger.com,1999:blog-15319370.post-5887772979793525212016-11-22T18:06:49.664+01:002016-11-22T18:06:49.664+01:00Unfortunatelly they say it is not a bug so I am on...Unfortunatelly they say it is not a bug so I am on the beginning. I'd like to be able to upload jdbc datasource through the API and edit it regularly in UI if needed :-(Dejanhttps://www.blogger.com/profile/00263648484184792884noreply@blogger.comtag:blogger.com,1999:blog-15319370.post-41438118036837440242016-11-22T15:03:06.167+01:002016-11-22T15:03:06.167+01:00Here are my findings about Mondrian schema uploadi...Here are my findings about Mondrian schema uploading. Mondrian schema file can be uploaded in three possible ways:<br /><br />1. Using the standard postAnalysis, so something like:<br /><br />curl -v -include --user admin:password -F "catalogName=test" -F "overwrite=true" -F "xmlaEnabedFlag=true" -F "parameters=DataSource=MYDATASOURCE" -F "uploadAnalysis=@path_to_schema_file.xml" http://mysite.com/pentaho/plugin/data-access/api/mondrian/postAnalysis<br /><br />2. Using import-export script that actally calls postAnalysis. Something like:<br /><br />import-export.sh --import --url=http://mysite.com/pentaho --username=admin --password=password --file-path=path_to_schema_file.xml --resource-type=DATASOURCE --datasource-type=ANALYSIS --analysis-datasource=MYDATASOURCE --overwrite=true<br /><br />3. Using plugin/data-access/api/datasource/analysis/catalog, sosomething like:<br /><br />curl -X PUT -v -include --user admin:password -F "schemaFileInfo=custom_name" -F "xmlaEnabledFlag=true" -F "parameters=DataSource=MYDATASOURCE" -F "uploadInput=@path_to_schema_file.xml" -F "overwrite=true" http://mysite.com/pentaho/plugin/data-access/api/datasource/analysis/catalog/test<br /><br />Note the parameter uploadInput and not uploadAnalysis as the documentation says<br />Dejanhttps://www.blogger.com/profile/00263648484184792884noreply@blogger.comtag:blogger.com,1999:blog-15319370.post-77077175587124851932016-11-22T10:33:35.775+01:002016-11-22T10:33:35.775+01:00Hi Dejan, thanks for your update! Much appreciated...Hi Dejan, thanks for your update! Much appreciated :)rpboumanhttps://www.blogger.com/profile/13365137747952711328noreply@blogger.comtag:blogger.com,1999:blog-15319370.post-22978666573982555462016-11-22T10:23:21.935+01:002016-11-22T10:23:21.935+01:00Hi,
If someone is interested, I have partially su...Hi,<br /><br />If someone is interested, I have partially succceded in uploading a custom JDBC datasource using plugin/data-access/api/datasource/jdbc/connection REST API but I got an error when tried to edit it through Pentaho UI. I have reported a bug and descibed all the steps here: http://jira.pentaho.com/browse/BISERVER-13454<br />Dejanhttps://www.blogger.com/profile/00263648484184792884noreply@blogger.comtag:blogger.com,1999:blog-15319370.post-30670519195839118592016-10-13T10:09:16.629+02:002016-10-13T10:09:16.629+02:00This comment has been removed by the author.Dejanhttps://www.blogger.com/profile/00263648484184792884noreply@blogger.comtag:blogger.com,1999:blog-15319370.post-3022701864627828422016-10-13T10:03:59.856+02:002016-10-13T10:03:59.856+02:00Hi Dejan,
> Did you maybe have a chance to try...Hi Dejan,<br /><br />> Did you maybe have a chance to try this?<br /><br />Nope, sorry :)<br />But maybe you can post it as a bug that you get Method not allowed? You might get some feedback that way on why it doesn't work.<br /><br />> My idea is to have a complete "synchronization" between two servers, so users/roles/permissions, repository content, mondrian schemas and jdni connections synced in one script<br /><br />Cool! I think many people would be interested in such a solution. Let us know how it goes :)rpboumanhttps://www.blogger.com/profile/13365137747952711328noreply@blogger.comtag:blogger.com,1999:blog-15319370.post-73393556972991481422016-10-13T08:21:02.499+02:002016-10-13T08:21:02.499+02:00Excelent article Roland!
I am using this for admi...Excelent article Roland!<br /><br />I am using this for administrating users on different servers (practically copying users/roles/permissions from one server to another) and it works great. I am trying to upload mondrian schema using curl and plugin/data-access/api/datasource/analysis/catalog/ api but it doesn't work as I always get "Method not allowed" error. Download works fine so I suppose I am using wrong parameters/headers or something. On the other hand, using the old plugin/data-access/api/mondrian/postAnalysis call works ok.<br /><br />Did you maybe have a chance to try this? My idea is to have a complete "synchronization" between two servers, so users/roles/permissions, repository content, mondrian schemas and jdni connections synced in one script.<br /><br />ThxDejanhttps://www.blogger.com/profile/00263648484184792884noreply@blogger.comtag:blogger.com,1999:blog-15319370.post-58472777831478577462016-08-30T21:50:45.032+02:002016-08-30T21:50:45.032+02:00Hi Shoaib,
thanks for your interest in this topi...Hi Shoaib, <br /><br />thanks for your interest in this topic!<br /><br />"Just to confirm is there any limitation with Rest APIs based on Pentaho editions (CE vs EE)?"<br /><br />Frankly, I am not aware of any limitations as such. Obviously, EE features that have REST/service counterparts are not available in CE, because those features are not in EE. But I do not believe the EE counterparts of services available in CE have more or better functionality.<br /><br />HTH, <br /><br />ROlandrpboumanhttps://www.blogger.com/profile/13365137747952711328noreply@blogger.comtag:blogger.com,1999:blog-15319370.post-49708890257449012582016-08-30T20:41:56.328+02:002016-08-30T20:41:56.328+02:00Thank you @Ronald
It was really helpful in getting...Thank you @Ronald<br />It was really helpful in getting started with Pentaho Rest APIs. Just to confirm is there any limitation with Rest APIs based on Pentaho editions (CE vs EE)?Anonymoushttps://www.blogger.com/profile/11004812189659222110noreply@blogger.comtag:blogger.com,1999:blog-15319370.post-7117110645087395612015-10-12T23:36:34.612+02:002015-10-12T23:36:34.612+02:00@Anonymous,
"i need to call php script using...@Anonymous,<br /><br />"i need to call php script using jQuery ajax call" <br /><br />This sounds rather generic - I don't see how it relates to my blog post.rpboumanhttps://www.blogger.com/profile/13365137747952711328noreply@blogger.comtag:blogger.com,1999:blog-15319370.post-71967581206590996742015-10-12T19:53:32.231+02:002015-10-12T19:53:32.231+02:00This is pretty understandable to calling Pentaho A...This is pretty understandable to calling Pentaho Api using Curl, i need to call php script using jQuery ajax call to fetch data and display the response on dashboard, but when i do this, it gives me 404 error :( someone help me please???Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-15319370.post-82907336122608951832015-06-28T21:30:37.699+02:002015-06-28T21:30:37.699+02:00@Carlos Villasana,
thanks for the kind words. It...@Carlos Villasana, <br /><br />thanks for the kind words. It's a good question. <br /><br />I cannot find a really clean way to do this. But maybe this might help:<br /><br />GET http://localhost:8080/pentaho/api/session/userWorkspaceDir<br /><br />(Requires Accept: text/plain header - no json or xml)<br /><br />This will return a string like: <br /><br />/home/admin/workspace<br /><br />The second part of this path is the user name.<br /><br />It might be possible to reconfigure pentaho so as to assign a different path for a user, in which case this workaround would break. But I am not aware how to go about such a reconfiguration, and I hope that this is a viable workaround for many environments. <br /><br />HTH, Roland<br /><br />PS: maybe you can make a JIRA case with a feature request for this functionality? It seems like a logical and sensible request to me.<br /><br />Best regards,<br /><br />Rolandrpboumanhttps://www.blogger.com/profile/13365137747952711328noreply@blogger.comtag:blogger.com,1999:blog-15319370.post-20140377654736763172015-06-28T20:47:03.507+02:002015-06-28T20:47:03.507+02:00HI Roland, excelent post.
Is there a way to get t...HI Roland, excelent post.<br /><br />Is there a way to get the current user logged in?<br /><br />I see in the reference that one can get all users, but I need the current user and don't see it.<br /><br />Thanks,Anonymoushttps://www.blogger.com/profile/15284981162423767721noreply@blogger.comtag:blogger.com,1999:blog-15319370.post-90264362925434957922015-01-16T16:01:17.899+01:002015-01-16T16:01:17.899+01:00Hi Roland
First of all, thanksfor your post, i...Hi Roland<br /><br />First of all, thanksfor your post, i't's helped me a lot (http://rpbouman.blogspot.pt/2014/10/performing-administrative-tasks-on.html)<br /><br />I wonder if you can help me. I'm having troubles with basic authentication with pentaho. Here you can see the thread in pentaho forum:<br /><br />http://forums.pentaho.com/showthread.php?180299-BASIC-Authentication-with-Pentaho-for-third-party-app<br /><br />Could you help me please, or if you can, make a post with basic auth for third-party apps??<br /><br />I don't know what else to do :(<br /><br />I would appreciate your help, best regards.<br /><br />JonathanUnknownhttps://www.blogger.com/profile/13201441165169042599noreply@blogger.com