Migrating HSQLDB to MySQL

HSQLDB migration to MySQL is not out of the box supported by mysql. The MySQL Workbench can only handle with dumps made by other mysql server. HSQLDB Transfer Tool is no longer bundled with the standard hsqldb jar file in the 1.8.x or later releases. After downloading and building with

ant hsqldbutil

you get in lib an additional hsqldbutil jar. With the hsqldb.jar, the hsqldbutil.jar and and mysql connector jar in my classpath i tried the Database Manager (From Tools menu choose transfer) from hsql with no luck. The MySQL Migration Toolkit has reached the EOL phase but works perfect for me. After downloading add the hsqldb jar to the lib folder C:\Program Files (x86)\MySQL\MySQL Tools for 5.0\java\lib. I update as well the mysql connector to the latest one.

1. Start your hsqldb server from command line
1. java -cp hsqldb-1.8.0.10.jar org.hsqldb.Server -database \
2. Start MySQL Migration Toolkit
3. Choose direct migration
4. Choose as Source a generic jdbc
5. Enter “org.hsqldb.jdbcDriver” as classname
6. Enter “jdbc:hsqldb:hsql://localhost” as connection string
7. Enter “sa” as username and leave password empty
8. click next
9. Configure your mysql connection
10. click next
11. choose public as schema
12. click next several time till screen “object creation options”
13. choose “create script file..” instead of “create objects online”
14. click next several time till screen “data mapping options”
15. choose “create script file..” instead of “transfer data online”
16. click next several time till screen “Summary”
17. click finish

With the sql you can use tools like phpmyadmin or the mysql workbench to import your data into the mysql server.

10+ Free Open Source BPM Platforms

December 2, 2014 by mb

link (http://butleranalytics.com/10-free-open-source-bpm-platforms/)

People have always created and modified business processes, but until business process management (BPM) tools became available it was often an informal and fairly ad-hoc procedure. There is nothing particularly complex about BPM, despite the unnecessarily elaborate terminology. In essence it provides a language for people to design, analyse, build, modify and discuss business processes. And it also creates a bridge between the process and systems used to implement it – assuming technology is a factor, as it nearly always is.

The business process management cycle starts with analysis and design – as do all creative projects. A diagramming notation is used to show the activities, routing and messages involved in a process – usually based on the BPMN (Business Process Model and Notation) standard. Business Process Management Systems (BPMS) provide a framework for these activities and a variety of tools to help in the design, implementation and monitoring of business processes. During the design and analysis phase a BPMS usually allows a design to be simulated, so that any undesirable side effects can be detected.

If a business process is to be more than just a diagram it needs to be plugged in to the operational systems. To this end BPMS offer connectors to various applications and support for methods such as Service Oriented Architectures (SOA), where existing systems can be made to behave as a set of services which a business process uses. Obviously this can become fairly technical – but no more than any other system implementation.

Finally we are ready to put the business processes into production where process instances (individual transactions and workflows) are handled. An essential part of this is the creation of a log of all process activities – invaluable material for the next phase.

Evaluating the performance of processes is a major benefit of a BPMS. The logs created during process execution can be interrogated to identify bottlenecks, loopholes, inefficiencies and any other form of poor performance. To this end process mining is a relatively new addition to many BPMS, where logs are interrogated for patterns of behaviour which are sub-optimal.

Of course this is just a brief over-view, and depending on the size of the organisation the whole process can become quite involved with thousands of processes having to be orchestrated. Even so these basic principles still apply.

Activiti is a light-weight workflow and Business Process Management (BPM) Platform targeted at business people, developers and system admins. Its core is a super-fast and rock-solid BPMN 2 process engine for Java. It’s open-source and distributed under the Apache license. Activiti runs in any Java application, on a server, on a cluster or in the cloud. It integrates perfectly with Spring, it is extremely lightweight and based on simple concepts.

Activiti supports all aspects of Business Process Management (BPM) in the full context of software development. This includes non technical aspects like analysis, modeling and optimizing business processes as well as technical aspects of creating software support for business processes. Activiti recognizes that BPM as a management discipline is a completely different aspect then BPM as software engineering.

Activiti’s primary purpose and focus is to implement the general purpose process language BPMN 2.0. And there is no single process language that can cover all the use cases well. In many cases a custom dedicated process language makes sense. So at the core, Activiti has the Process Virtual Machine architecture. That means that any custom process language can be build on top of it.

Bonita BPM improves business operations by connecting people, processes, and information systems into easily managed applications. Use Bonita Studio to map the organization, define the data structure, build the user interface, and create actionable reports. Bonita Portal creates a central location to perform tasks, monitor case completion, search for information, and collaborate with peers.

Camunda is an open source platform for workflow and business process automation. It executes BPMN 2.0, is very light-weight and scales very well. Camunda is written in Java and a perfect match for Java EE and Spring while providing a powerful REST API and script language support. You can use camunda BPM for system integration workflows as well as for human workflow and case management.

You can add camunda to your Java application as a library. You can also use it as a container service in Tomcat, JBoss etc., so it can be used by multiple applications which can be redeployed without shutting down the process engine. Some of the biggest companies in the world and most trusted public institutions rely on camunda.

Intalio bpms provides a comprehensive enterprise-class platform to design, deploy, and manage the most complex business processes; over 1000 organizations world-wide in all industries rely on the technology to manage their mission-critical business processes. Intalio bpms features an intuitive and powerful visual designer and a reliable high-performance process execution server. It also includes enterprise-level capabilities such as business activity and metrics monitoring, business rules and decision management, document management, mobility support, and system integration tools and portals.

jBPM is a flexible Business Process Management (BPM) Suite. It makes the bridge between business analysts and developers. Traditional BPM engines have a focus that is limited to non-technical people only. jBPM has a dual focus: it offers process management features in a way that both business users and developers like it. The core of jBPM is a light-weight, extensible workflow engine written in pure Java that allows you to execute business processes using the latest BPMN 2.0 specification. It can run in any Java environment, embedded in your application or as a service.

jSonic BPM suite enables enterprise owners to align business processes with the dynamic market conditions, statutory compliances and, customer and partner requirements. It is a comprehensive solution that improves the bottom line of organization by increasing process efficiency, optimizing resource utilization and automating human workflow system.

jSonic BPM suite, the Open Source BPM Software offers an all-encompassing solution covering process designing, modeling, executing, automating and monitoring as per the business needs and wants. The major components of the suite include Process Management, Workflow Management and the Interface Designer.

Orchestra is a complete solution to handle long-running, service oriented processes. It provides out of the box orchestration functionalities to handle complex business processes. It is based on the OASIS standard BPEL (Business Process Execution Language). Orchestra’s objectives:

• Improvement and control of processes
• Services interaction
• Productivity and agility of the company

Orchestra is fully Open Source and is downloadable under the LGPL License.

ProcessMaker is a cost effective and easy to use open source business process management (BPM) or workflow software application. Workflow software such as ProcessMaker can assist organizations of any size with designing, automating and deploying business processes or workflows of various kinds.

ProcessMaker workflow software features an extensive toolbox which provides the ability to easily create digital forms and map out fully functioning workflows. The software is completely web based and accessed via any web browser, making it simple to manage and coordinate workflows throughout an entire organization – including user groups and departments. ProcessMaker workflow software can also interact with other applications and systems such as ERP, business intelligence, CRM and document management.

Red Hat JBoss BPM Suite is the JBoss platform for Business Process Management (BPM). It enables enterprise business and IT users to document, simulate, manage, automate and monitor business processes and policies. It is designed to empower business and IT users to collaborate more effectively, so business applications can be changed more easily and quickly. Create, test, deploy and monitor BPMN2-based business processes to optimize enterprise workflows and automate critical processes. Includes all the business rules and event processing capabilities of Red Hat JBoss BRMS. Easily create real-time dashboards to monitor key performance indicators for running processes and activities.

Talend’s BPM products enable managers, business analysts, developers and end users to model current processes, collaborate on improvements, and rapidly create and optimize process-driven solutions in minutes. Talend combines three solutions in one: an innovative process modeler, a powerful BPM and workflow engine, and a breakthrough user interface for the creation of forms. You can create human interactive or process-based applications, and automate and optimize business processes in a single day.

How to design and develop an interactive Cockpit or Dashboard in SpagoBI?

Dashboard is a one page visualization of business performance data which keeps senior managers in-line and proactive. This helps in taking better business decisions and planning future business needs. The key here is to present business performance data efficiently so that it can benefit business owners and help them analyze different aspects of their business.

To design and develop interactive cockpit in SpagoBI, we would need the following:

1. A document of Type “Document Composite” and Engine “Document Composition Engine”.Notes: Make sure the engine has been configured in “Resources->Engines Management page. It can be configured while installing SpagoBI 3.4 (latest version) from windows installer.
2. The XML file to design/develop the view and navigation of our cockpit. This is an xml template that we can write only by hand now but in future it will be written by wizard.

Interactive Cockpit Template Detail

This tag defines a template that will be used for rendering documents. It’s a standard template and must not be changed.

This tag defines the size of the video/view, we can have size in percentage mode as well (the alternative is pixel). When not defined the default values are 1024 x 768.

There is a block for every document that we would like to view/present in our cockpit/dashboard. We can add as many document tags as we need depending upon our views requirements. There is no limit and so we can create a composite document with 2,3,4,6, … sub-documents and everyone can shows different layout. The only limit is our common sense, because see too many documents can create confusion rather than help the data analysis.

sbi_obj_label defiines the label  by which the document is saved into SapgoBI.

SpagoBIMobileEngine: Bringing Business Intelligence to mobile devices

It is not surprising for Business owners to think of taking business decisions right from their gadgets with which they spend most of their time these days. Be it I-Pads, Tablets or the Smart phones, they are all part of our life now. What if those BI Reports you see in your browsers are made available on your I-Pad!…. I know you must be thinking there are many such applications, but what about an Open Source application which has provision for rich controls.

   

In this Blog, lets have a look at SpagoBIMobileEngine, one of the latest offerings of the new version of SpagoBI 3.4.

Now we can display our BI reports on mobile devices. This new component allows us to deploy the analysis available in SpagoBI suite onto mobile devices, such as smartphones and tablets, using original types of reports, graphs and interactive cockpits.

We have following three features added by SpagoBI for mobile so far:

1. Mobile Table: gives a tabular layout to data loaded from the associated dataset
2. Mobile Chart: displays Sencha-Touch charts over dataset data
3. Mobile Cockpit: composes charts and reports in a single layout, within the possibility for each document to interact with the others, passing them parameters

Here is our first experience in creating different kind of reports provided by SpagoBIMobileEngine.

Develop Mobile Table

Please follow the steps below to develop mobile table:

1. Create an analytical document with the following required information:
1. Label: the label of the document
2. Name: Name of the document.
3. Type: Mobile Report
4. Engine: Mobile Report Engine
5. Data Source: your data source, e.g. foodmart.
6. Dataset: locate the dataset for which you would like to develop table.Notes: Make sure the engine has been configured. This is configured by default with version 3.4.
2. Locate and upload the document template (.xml) file.

Details on the document template

This is the start of the table chart template.

         

Title of the bar chart document.

This is for legend where we set the position of the legend, one can comment this line in case they do not want to have legend on the page.

Display the value of the numeric control as we move the slider or needle.

This is animate configuration tag, which shows motion effect.

Other easing values, but I have no idea if SpagoBI supports all of these:

bounceIn, bounceOut, bounceInOut, elasticIn, elasticOut, elasticInOut, linear, quadIn, quadOut, quadInOut, cubicIn, cubicOut, cubicInOut, easeIn, easeOut, easeInOut, quartIn, quartOut, quartInOut, quintIn, quintOut, quintInOut, sineIn, sineOut, sineInOut, expoIn, expoOut, expoInOut, circIn, circOut and circInOut

SALES

COSTS

X

Configure series and axes to set/display fields on X and Y axis.

Interaction configuration, The PanZoom interaction allows the user to navigate the data for one or more chart axes by panning and/or zooming.

Pie Chart

Set the width and height of the pie chart.

The title of the document.

Legend configuration.

Configure interactions, type=rotate will rotate the chart with touch.

true

Set animation as true.

Configure series to set/display fields in pie chart.

End of the widget.

Line Chart

Set the width and height of the pie chart.

Set the title of the document.

Configure legend position.

Animate configuration same as above.

value1

value2

month

Configure series and axes to set/display fields on X and Y axis.

Interaction configuration, The PanZoom interaction allows the user to navigate the data for one or more chart axes by panning and/or zooming.

      3. Save and execute the document.

Develop Mobile Cockpit
Please follow the steps below to develop mobile table:

1. Create an analytical document with the following required information:
   1. Label: the label of the document.
   2. Name: Name of the document.
   3. Type: Mobile Cockpit
   4. Engine: Mobile Cockpit EngineNotes: Make sure the engine has been configured. This is configured by default with version 3.4.
2. Locate and upload the document template (.xml) file.

Details on the document template