CN

A new feature from MashZone 2.0 allows the use of new data sources. The JAVA Database Connectivity (JDBC) plays an important role here. It allows users to establish connections to different database models. However it should be noted, that the JDBC isn't included in delivery with MashZone. Where you can get it and how you install it, will be described later.

In this post I will show you how to establish a connection with the help of an Oracle Database and output the data records of  demo tables.

First you must decide which database to use. As mentioned above, I decided to use an Oracle Database in the Express Edition, because it’s popular and has a demo data record. To use it, you must configure certain allocations. This How To assumes that the database user “HR” is unlocked and otherwise the JDBC Driver of Oracle is copied in the MashZone folder. This can be done in the following manner:

Open the Adminstration interface of Oracle http://127.0.0.1:8080/apex/ and log in with “system” and the password you specified in the setup. Afterwards, switch to the user administration, unlock “HR” and change the password.

Alter User

Change Password

Now you need the JDBC Driver so that MashZone can establish a connection to the database. This is the default setup folder, which was automatically selected during setup:

C:\oraclexe\app\oracle\product\10.2.0\server\jdbc\lib

Copy  the file “ojdbc24.jar” and paste it accordingly in the subfolder “jdbcdrivers” of MashZone 2.0.

 

Now, to set up the database, reboot the MashZone server, switch to the "Administration" tab and select the new item "Database Connection". Once there click on "Create" and enter the following values:

Add Connection

Driver: oracle.jdbc.driver.OracleDriver

Database URL: jdbc:oracle:thin:@localhost:1521:XE

When your input is saved, click the button "Test database connection" to test the settings you entered. Now you are asked to specify the user data for the test connection.

Connection Test

If your login was successful the following message appears: "Connection test with database ‚Oracle Database‘ successful."

Now switch to the Feed editor, create a new data feed and select "Database" as the data source. The following shows a window that displays the database you just created.

Database Source

Select Database Connection

 

Now select this database and confirm it with „OK“. As user enter the user “HR” which was already tested above. For this post, I invented a connection between the employees and their departments as an SQL statement. Due to this, the IDs between “Employees” and “Departments” were compared: „SELECT First_Name, Last_Name, Department_Name FROM Employees, Departments WHERE Employees.Department_ID = Departments.Department_ID“

Database Query

If you want to experiment with your own instructions, there are several programs that can help you:

SQuirrel
- Eclipse- DBVisualizer

 

A detail of the results can be seen in the following table:

Result Demo Database

 

Congratulations on your first database connection in MashZone 2.0!

Note: See this post for a list of other articles about MashZone 2.0. You might be also interested to join the ARIS MashZone group at ARIS Community.

by Michael Bevilacqua
Posted on Thu, 10/21/2010 - 20:16

Comment pending review.

0
by Mojtaba Hedayatinia
Posted on Tue, 12/21/2010 - 11:21

Dear Christian,

Thank you very much for this post. very useful.

0
by Markus L.
Posted on Fri, 05/27/2011 - 09:20

Dear Christian,

do you have a comparable tutorial to connect ARIS MashZone to MS SQL Server? That would be helpful :-)

0
by Stephan Freudl
Posted on Mon, 05/30/2011 - 10:14

Hi Markus,

no we have not but it is already part of your database vendo's documentation. All you need is its JDBC driver and its JDBC URL connection string.

Regards

Stephan

0
by Parth Magu
Posted on Mon, 05/29/2017 - 13:11

In reply to by Stephan Freudl

Stephan ,

I have a query I am new to Aris .

Below is the query .

eeed your help 

Hi All ,

 

I need Help .

I am using Aris mashzone 2.3.1.0.1656 Version .

I am using mysql-connector-java-5.1.5.jar 

FIle installled in jdbcdriver folder in Linux .

I am able to connect to database with jar file .

 

However When I am running query in mashzone it throws me an error message .

"

Incomplete operator parameterization. The following fields or properties are not initialized:

Configure columns 

Can you please let me know where I am going wrong .

SQL queries executes fine in My SQL Yog .

Regards

Parth 

0
by Kees Hoogenboezem
Posted on Thu, 01/10/2013 - 16:13

Dear Christian,

UPDATE: !@#$%^&*()_ it is working.

After writing this message I tried it again. I deleted the connection, made a new one with the same driver and it's working (no restart MashZone).

It looks like it is necessary to create a new connection when you change the driver.

We are trying to use  ARIS Mashzone 2.3 but we cannot connect to the Oracle database.

I have tried several drivers but all of them give an error:

The following error occurred when connecting to database "ARIS test": No suitable driver found for jbc:oracle:thin:@oyama.hhs.nl:1521:aristest

 

We are also using Business Publisher with jdbc and is working fine. I tried this driver and downloaded several drivers from Oracle. But all of them are giving the same error (after restarting Mashzone).

Do you have any suggestions?

 

Kees Hoogenboezem

 

 
0
by Kushal Bangabash
Posted on Thu, 02/07/2013 - 13:51
Hi All,

I am new to ARIS MashZone and am facing an issue. I am connecting to Oracle database and am fetching some records for my data feed to be later used in a mashApp.

The connection is successfully tested but after every 4-5 runs to fetch the data from the data feed, i receive an error stating all database connections are in use and the connection fails.

I tried to increase the connection pool but it is somehow not helping the cause. I have also noted that if i test the connection after i receive this error, the connection test works fine and is successfull.

This is hard for me to work out and would need assistance from you all.

Thanking in advance,

Kushal Bangabash

0
by vijay kumar
Posted on Wed, 02/13/2013 - 15:45

Hi Kushal,

please check the no of connection you provided from the aris mashzone under admin page.

also check the cache time u have set to have the data fetch from the datafeed to fetch the data.

I assume u are connecting to the data base and the cache time set is default 5 sec. which is too low and also the no of connections available are less in number so there is no connnections left after few hrs.

 

Please share screenshots of the above if that doesnot work.

 

Also tell how frequently u are assessing the Database through the aris mash app .

 

Thanks,

Vijay.

 

0
by Parth Magu
Posted on Mon, 05/29/2017 - 13:06

Hi All ,

 

I need Help .

I am using Aris mashzone 2.3.1.0.1656 Version .

I am using mysql-connector-java-5.1.5.jar 

FIle installled in jdbcdriver folder in Linux .

I am able to connect to database with jar file .

 

However When I am running query in mashzone it throws me an error message .

"

Incomplete operator parameterization. The following fields or properties are not initialized:

Configure columns 

Can you please let me know where I am going wrong .

SQL queries executes fine in My SQL Yog .

Regards

Parth Magu

 

"

 

0

Featured achievement

Rookie
Say hello to the ARIS Community! Personalize your community experience by following forums or tags, liking a post or uploading a profile picture.
Recent Unlocks

Leaderboard

|
icon-arrow-down icon-arrow-cerulean-left icon-arrow-cerulean-right icon-arrow-down icon-arrow-left icon-arrow-right icon-arrow icon-back icon-close icon-comments icon-correct-answer icon-tick icon-download icon-facebook icon-flag icon-google-plus icon-hamburger icon-in icon-info icon-instagram icon-login-true icon-login icon-mail-notification icon-mail icon-mortarboard icon-newsletter icon-notification icon-pinterest icon-plus icon-rss icon-search icon-share icon-shield icon-snapchat icon-star icon-tutorials icon-twitter icon-universities icon-videos icon-views icon-whatsapp icon-xing icon-youtube icon-jobs icon-heart icon-heart2 aris-express bpm-glossary help-intro help-design Process_Mining_Icon help-publishing help-administration help-dashboarding help-archive help-risk icon-knowledge icon-question icon-events icon-message icon-more icon-pencil forum-icon icon-lock