Pentaho 5.2 available - And so is CE!

238 views
Skip to first unread message

Pedro Alves

unread,
Oct 9, 2014, 8:20:59 AM10/9/14
to pentaho-...@googlegroups.com

5.2 CE Release Available

Pentaho 5.2 is out! And... CE is also available! Get it at the usual places

Changes you'll notice

Of course, apart the huge amount of bug fixes and overall improvements...

New marketplace on the BA server






The new marketplace is ready to be included on the BA server CE distribution. Biggest change is the inclusion of the Maturity Level Classification concepts, so that users and administrators know the maturity level and support implications of each plugin.

A web version of the marketplace


Accessing the Marketplace requires a running version of the BA server or PDI installed. Which makes things a bit hard for people that don't have access to a running version of the BA server or PDI.
We now have a web version of the Marketplace, where one can navigate both the BA server and PDI marketplace entries. Check it in http://pentaho.com/marketplace

A new theme

We have a new theme available in the marketplace! Try the new Emerand theme! Looks sweet, and also gives a great example of how to develop your own themes (and submit them to the marketplace)

Crosstabs!

A major reset was done on the PRD crosstabs story. All of the jiras were closed as "won't do" and 2 were opened to improve the existing experimental features of crosstabs.
As of 5.1, the existing crosstab interface only allowed a "one way" generation; If a report writer wanted to change some field, he had to delete the element and do again. Also, it was his responsibility to make sure the dataset would be sorted by the appropriate fields. In 5.2 that interface is now editable and the dataset will be sorted appropriately.
If you wanna try it, just flip on the "experimental features" and you'll be able to get it! Supply feedback so we can improve it!

Kettle Platform inspector


I love this one. It's absolutely huge. It's a magical kettle step, part of the BA server utils that allows us to communicate with the BA server, get the list of endpoints made available by it, and in a very simple way execute actions on the platform. From simple things like getting the platform version to automate the creation of users, datasources or even calling Sparkl endpoints.
When published in the BA server, PDI transformation that use this step can do a local execution, bypassing the specified authentication and running with the permissions attached to the current user.
An extremely powerful step, and a fundamental piece in the strategy of bringing PDI and the BA server closer together.
This step is now available on the PDI marketplace, on the baserver-utils project.

Ctools on by default - And Sparkl!

Since what everyone does from day one in CE is to install the Ctools (and sometimes they even manage to do it wrong by mixing versions or something), starting on 5.2 we'll be including the more recent stable version of the Ctools and also Sparkl.

Comming soon, CST available in the marketplace

The CST plugin, Community Startup Tabs has been converted to 5.0, sponsored by one of our customers. We'll be making this one available through the BA server Marketplace.


-pedro

Tim Richardson

unread,
Oct 16, 2014, 3:24:13 AM10/16/14
to pentaho-...@googlegroups.com
Are there upgrade instructions? For me, upgrading pentaho community editions is a bit of a headache (on Windows). 
Basically, I copy to a new folder, edit server.xml for a port. If I close down the existing instance I can start the new one. I need to close the existint service because hsqldb occupies a port and I haven't worked out where to change that.

So I can get the new server running. But then do I manually transfer users, data connections and republish schemas? I have done this in the past but now I have real people using it, real reports and dashboards etc.  I wonder if I am missing something. 

Pedro Alves

unread,
Oct 16, 2014, 3:34:21 AM10/16/14
to pentaho-...@googlegroups.com

Cbf, obviously!
--
You received this message because you are subscribed to the Google Groups "Pentaho Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to pentaho-commun...@googlegroups.com.
To post to this group, send email to pentaho-...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/pentaho-community/92c0a4d7-3a11-48b6-ae4b-134c04b34239%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Nelson Sousa

unread,
Oct 16, 2014, 3:45:06 AM10/16/14
to pentaho-...@googlegroups.com

cbf works with 5.x?

Nelson Sousa
Business Intelligence Consultant


Pedro Alves

unread,
Oct 16, 2014, 4:05:49 AM10/16/14
to pentaho-...@googlegroups.com

Nelson Sousa

unread,
Oct 16, 2014, 4:41:56 AM10/16/14
to pentaho-...@googlegroups.com

Prove it. Write a blog post with a tutorial about deploying 5.2 ce using cbf ;)
To view this discussion on the web visit https://groups.google.com/d/msgid/pentaho-community/CAC_LyUhxp%2BivjBBp%3DJ7xqraTYbPjJhhTMBptiEBVi0wuTq9JYQ%40mail.gmail.com.

For more options, visit https://groups.google.com/d/optout.


--

Pedro Alves

unread,
Oct 16, 2014, 5:45:26 AM10/16/14
to pentaho-...@googlegroups.com

Nelson Sousa

unread,
Oct 16, 2014, 6:22:02 AM10/16/14
to pentaho-...@googlegroups.com


good stuff.

I assume there won't be many changes required for 5.2, but I'll test it and let you know.

How do you go about to just move solutions files over? Using the repository synchronizer? Or is there a better way? The concept of a solutions folder doesn't exist anymore, at least not in the good old 3.x, 4.x context, so, I'm curious.

Cheers



Nelson Sousa
Business Intelligence Consultant


Rogier Wessel

unread,
Oct 16, 2014, 6:45:57 AM10/16/14
to pentaho-...@googlegroups.com
I would guess import-export.sh on the running server?!

If not, I would very much like to know.

${PENTAHO_APP_HOME}/biserver-ce/import-export.sh --import --url=http://$PENTAHO_HTTP_HOST:$PENTAHO_HTTP_PORT/pentaho --username=$PENTAHO_ADMIN_USER --password=$PENTAHO_ADMIN_PASSWORD --charset=UTF-8 --path=/home --file-path=${SCM_ROOT}/${SCM_PROJECT}/pentaho-solutions/dashboards.zip --overwrite=true --permission=true --retainOwnership=true

Btw on a related note, how do you import / export the saiku files as the handling of exports is slightly changed from 5.1 onwarts (${PENTAHO_APP_HOME}/biserver-ce/pentaho-solutions/system/importExport.xml).

Pedro Alves

unread,
Oct 16, 2014, 7:38:50 AM10/16/14
to pentaho-...@googlegroups.com

Nelson Sousa

unread,
Oct 16, 2014, 7:45:38 AM10/16/14
to pentaho-...@googlegroups.com

Ok, thanks.

Nelson Sousa
Business Intelligence Consultant


Tim Richardson

unread,
Oct 16, 2014, 5:40:06 PM10/16/14
to pentaho-...@googlegroups.com
Hi Pedro,
was "Cbf, obviously!" an answer to my question about upgrading from CE 5.1 to 5.2? 
I thought there may be something similar. 

I have the Repository Sychronizer plugin installed but I don't know how to access it (there is no menu item I can see anywhere)
To unsubscribe from this group and stop receiving emails from it, send an email to pentaho-community+unsubscribe@googlegroups.com.
To post to this group, send email to pentaho-community@googlegroups.com.

Pedro Alves

unread,
Oct 16, 2014, 5:52:03 PM10/16/14
to pentaho-...@googlegroups.com
Yes it was 

And for the repository synchronizer make sure you have the ctools installed and working. Should then appear under the tools menu 
To unsubscribe from this group and stop receiving emails from it, send an email to pentaho-commun...@googlegroups.com.
To post to this group, send email to pentaho-...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/pentaho-community/3e9d4d6d-edee-4fd5-b971-43ae41314367%40googlegroups.com.

Tim Richardson

unread,
Oct 20, 2014, 6:44:25 AM10/20/14
to pentaho-...@googlegroups.com


On Friday, October 17, 2014 8:52:03 AM UTC+11, Pedro Alves wrote:
Yes it was 

And for the repository synchronizer make sure you have the ctools installed and working. Should then appear under the tools menu 
I have all dependencies installed. ctools is working for dashboards. But no repository synchroniser entry in the tools menu.

so I tried the import-export scripts
the import-export.bat script fails because it looks like it actually is a unix shell script. I have bash on this server as part of the windows git tools.
When I do this:-
import-export.sh --export --url=http://localhost:8082/pentaho --username=admin --password=password --file-path=c:/temp/export.zip -charset=UTF-8 --path=/public --logfile=c:/temp/logfile.log  --withManifest-true  
(basically the example given by the script) it fails with this error: 
ERROR CommandLineProcesses - Illegal character in path at index 46: http://localhost:8082/pentaho.api/repo/files/C:    Program Files (x86):Git:public/download?withManifest=true

so somehow it is including the directory of the bash executable (my guess) in the URL. 
Entering the URL manually into a logged-in sessions makes a zip file so I will explore that.




 

Pedro Alves

unread,
Oct 20, 2014, 6:49:35 AM10/20/14
to pentaho-...@googlegroups.com

Check the logs - it should just work.... (repository synchronizer, I mean)




To unsubscribe from this group and stop receiving emails from it, send an email to pentaho-commun...@googlegroups.com.
To post to this group, send email to pentaho-...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/pentaho-community/f86ed75c-5f15-4f75-bb08-e88abf18e19a%40googlegroups.com.

Tim Richardson

unread,
Oct 20, 2014, 7:29:15 AM10/20/14
to pentaho-...@googlegroups.com


On Monday, October 20, 2014 9:49:35 PM UTC+11, Pedro Alves wrote:

Check the logs - it should just work.... (repository synchronizer, I mean)


I got the import-export.bat script working. I had to reduce the memory given to java. It does not create users though.
So step (1) appears to be export/import users.
Then step (2) would be the connections
Step (3): the repository, which I can do now. 


Reply all
Reply to author
Forward
0 new messages