PO

Hi,

does anyone what is needed to connect Aris with my own Postgresql dbms? 

Regards,

Peer

by Runé Becker
Badge for 'Mastermind' achievement
Posted on Fri, 06/03/2016 - 19:39

Dear Peer,

Officially ARIS supports its own embedded PostGreSQL and as external DBMS Oracle and MS SQL Server.

What advantage do you expect when running ARIS on another PostGreSQL?

Cheers

Rune

0
by Peer Oltrogge Author
Posted on Sat, 06/04/2016 - 15:17

Hi Rune, 

thanks for answering. Actually it leads to  rather different questions.

Firstly, how can i analyse the locale/embedded PostGreSQL, so i don't have to use the ARIS reports to work on the database? I don't really know who to connect to the embedded PostGreSQL to work with other reporting tools. 

Same question to external DBMS Oracle or MS SQL Server.

Do you have any recommendations?

Thirdly, I'm a student and using the university license. Do i mandatory need a ARIS Connect/Design/etc. Server. Or can i connect ARIS on one of the external options (DBMS Oracle or MS SQL Server)

Greetings

Peer

 

0
by Runé Becker
Badge for 'Mastermind' achievement
Posted on Sun, 06/05/2016 - 19:21

Dear Peer,

I strongly recommend to use the official interfaces to access/extract ARIS data:

  • ARIS Script API: Writing reports in JavaScript to read/write ARIS data
  • ARIS RESTful API: Read/write ARIS data from mobile apps or third party programs
  • XML file export: Exporting an ARIS database in an ARIS-specific XML format (.AML)

Bypassing ARIS for directly accessing its persistence layer could easily lead into consistency issues when changing data, or to data access conflicts when ARIS runs in parallel to the external DBMS access. Therefore, a direct access to its DBMS is not supported.

Please post in the forum http://www.ariscommunity.com/forums/university-relations to get support on the restrictions of our educational packages.

Cheers

Rune

0
by Peer Oltrogge Author
Posted on Sun, 06/05/2016 - 23:48

In reply to by rbe

Hey Rune,

thank you very much again for your answer. This makes kind of sense, since i heard that ARIS is saving the data pretty much confusing. So, for example for the embedded PostGreSQL, i can not use any tool to send SQL queries to the DBMS?

If that is not possible, what do you recommend to combine ARIS Report output with other documents from word, excel, visio etc., so i can create one new document with all these information merged?

Thank for helping! 

Peer

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