Dear all
if i connect aris to sql server database instead of derby , can i see all the tables that contain the models , objects and connections???
i'm asking this question because i'm searching on a way to create report directly from sql server instead of writing ARIS script .
i'm just wondering if i can get all the contents of ARIS databae in a form of tables , then i can play with these tables using sql reporting service to create reports about models , objects .....etc
thx
Hi,
It is very tempting when we all know the SQL is easier to extract data from database. And it would be really tempting if you are from database background. I als have strong database background having worked both as DBA and front end developer and guess what I also thought same and wanted to get the report through SQL directly instead of through ARIS reporting.
However having looked at the Oracle and SQL server data (as we have Oracle setup and now chnaged the setup to SQL server) I can safely say it is not worth trying to get information from SQL server directly. The data is stored in complex format with over 100 of tables and keeping the information in GUID's etc.
ARIS reports are much easier to develop and you can get information much quicker. With little knowledge of JAVA you can create most of the basic reports to get information out of ARIS. You can also use ARIS Reporting Wizard which is self explanatory and is much quicker way to get information.
Regards
Abhijit Das