Can anyone make any recommendations on the best way to read data from the ARIS database?
We are using the Sybase ASA database.
16 Replies
-
Hi Russell,
why don't you just use the reporting functions that ARIS offers?
Regards,
Markus
-
Hi Russell,
I agree with Markus, probably the best way to access data form the Aris DB is with the reporting functions that Aris offers.
It doen´t have the best API, but is easy to get started.
See ya.
-
Hi Pedro,
we also offer the WYSIWYG editor now. Using it makes it very easy to output some information, and you don't have to use the API.
Regards,
Markus
-
Using third party reporting tools won't work very well. The actual database structure that ARIS uses is very generic, as it is with most modeling tools. Also, reporting directly against the database is a bad idea as IDS Scheer (or Software AG now) is free to change the structure from release to release. The API is the way you need to access the data is you wish to do it outside of ARIS.
There is a thrid party option Cogniscape by Cogniviz. They provide dynamic access to the content of the ARIS DB.
-
Hi Russell,
what exactly do you want to report?
Perhaps I can offer you some help to solve the problem using the WYSIWYG editor.
Cheers,
Markus -
Thanks everyone for your advice.
I'll check out the WYSIWYG Report editor.
-
Hi Russel,
it is part of the ARIS Business Architect.
Go to the module Administration and connect to the server.Now you can select evaluation, then reports and a category(or create a new one) where you want to create your report.
In the now appearing wizard you can specify the context to start the report. Important is on page "Output" to select "Use report template (design view)" and also define a template.
I hope this makes it easier to start with the WYSIWYG editor.You will find a small tutorial in the ARIS Help (create scripts - use cases - How to work with report script templates)
If you have further questions, don't hesitate to ask.
Regards,
Markus
-
I use the find functionality and queries frequently and then copy the results to excel for analysis.
Yesterday I wanted to identify and count how many models with duplicate names I had in my db. I did a query found all models plus level attribute
copy to excel, import to ms-access, query on name, model type, level- count the duplicates.
export query results back to excel as a unique list of duplicate models and the number of duplicates per model name, type, level...
Results-time to enforce some conventions about model names.
-
Hi Donald,
you may use the WYSIWYG-report designer to create an excel output.You create a report with an database as context, and choose excel as output.
Now you can create a datatable for all models, and sort them by name, type and group hierarchy.
Then choose the datafields you want to be part of the output.
See the attached screenshot.
I hope this would make your work easier.
Regards,
Markus
-
We are using 7.0.2 currently in production
the copy and paste is quicker than creating the report in most cases.
thanks
donald
-
Ok,
the WYSIWYG designer is part of ARIS 7.1. I am sorry, but you won't be able to do it that way.
Using it (with 7.1), it took me about 2 minutes to create the report, so it will be faster when resuing it frequently.Bye,
Markus
-
Hey thats very useful help to knowing where to find the proper scripts to start to work...
Anyway i'm new here and recently i starting to work with BPA, BPM the ARIS tools of course.. so i got a question, recently i finished the documentation (modeling) of a few proccess and i print some test reports and the people who evaluate the information ask for a little modifications to the format (basically hide or dont show some data).. he send me back a simplified report with highlight yellow fields wihch are the ones he wants to don't be visible on the final reports... so here is the report:
Can you please help me about recognize the fields of the scripts wich are corresponding to those fields?? (i was reading the scripts and i think there is one specific script which has the lines that can be modified to solve this).. any help would be very useful to me.. Thanks for reading me and thanks for all the knowledge expressed in this community!
-
Hi,
are you using the design view (wysiwyg-editor)?
Cheers,
Markus
-
Hi!.. thanks for ask (i forget to detail that). Not really, actually i was looking the code and searching in the files located at Evaluation/Reports folder (maybe those aren't the right ones?)
Anyway i'm working with Aris IT Enterprise Architect 7.1, i should look for the desing view this time??
Thanks for your attention, i will be looking for your help.
-
Finally i change the focus and i begin to use the design view.. so changing options and trying to figure out how it works i was ablle to do a report:
But i have problems with the filtering options, i have a full EPC model with many events, functions and this functions has some inputs and outpus plus responsable people in charge... basically i want to print some repor in this format:
HEADER
1. Diagram name
(Screenshot of the diagram)
2. Diagram details
Table of contents:
__________________
Name of function 1
----------------------------
Description of function 1
----------------------------
Input 1 of function 1
----------------------------
Input n of function 1
----------------------------
Output 1 of function 1
----------------------------
Output n of function 1
----------------------------
People on charge of function 1
----------------------------
People on support of function 1
----------------------------
Name of function n
----------------------------
...
----------------------------
People on support of function n
FOOTER
And so on with all the functions involved on the diagram... as you can see on the above image i was able to show all the functions with the respective description... Thanks!
-
Well to add more information, i made manually a report with the format which i need:
Thanks for your attention.