Currently I am looking to setting up IBM Rational System Architect 188.8.131.52, however I need to get a database setup first to connect with it. I see from the system requirements it only supports SQL Server/Oracle. Due to various restrictions, I am unable to use this currently and the only available option is DB2. Is it possible to hook System Architect to DB2, and if so, how?
I already know that there is a way to do this, however cannot seem to find out, as another team in a separate department has done exactly this. However I was wondering if anyone here had any better solutions, examples, or anything that would assist with this task. Perhaps a way to make the DB2 server look like an SQL server to System Architect, or a roundabout way of connecting the two.Answer1:
DB2 is also product of IBM. The generic install should contain the necessary JARs to connect to DB2:
Directory of C:\Program Files\IBM\SDP\runtimes\base_v61\deploytool\itp\plugins\ com.ibm.datatools.db2_1.0.3.v200805071403\driver 2012-11-02 20:31 1,973,658 db2jcc.jar 2012-11-02 20:31 2,068 db2jcc_license_cisuz.jar 2012-11-02 20:31 1,015 db2jcc_license_cu.jar 3 File(s) 1,976,741 bytesAnswer2:
I know that this may be a little late, but just wanted to correctly provide a response for System Architect's (SA) support for DB2.
If you are looking at using DB2 for storing the SA encyclopedias, then this is not supported. SA only supports SQL Server and Oracle as it's back-end repository to store the various artifacts (diagram, definitions, etc) i.e. an encyclopedia.
Hope this helps.