53491

IBM Rational System Architect using DB2

Question:

Currently I am looking to setting up IBM Rational System Architect 11.4.3.0, 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 bytes

Answer2:

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.

Recommend

  • sbt-unidoc — how to exclude a sub-module from a RootProject
  • Convert to currency or money format in DB2
  • Mysql InnoDB performance optimization and indexing
  • handling $http.get and $http.post errors in Angularjs
  • Image Resizer User.Identity in eventhandler
  • Bind Xaml bitmap image
  • Processing (too) many XML files (with TagSoup)
  • ember js subviews and didinsertelement event
  • Using Select and where statement in Criteria
  • Find symbol dependencies in source code [closed]
  • Eclipse dark color theme fixes
  • Does argparse support multiple exclusive arguments?
  • Codeigniter Hooks advance
  • Getting data from database using HQL
  • How to merge two Request in Laravel
  • Many to many relationship core data query for specific collection
  • What is this strange character in chrome's resource css viewer?
  • How to repeat sections of a SQL query across UNIONs? (DRY in SQL)
  • how to populate a SQLite database and use that database in phonegap?
  • Passing variable arguments using PowerShell's Start-Process cmdlet
  • How can I replace the server in Web Component Tester
  • Creating a DropDownList
  • Who propagate bugfixes across branches (corporate development)?
  • SAVE attribute needed for Fortran variables when only the C_LOC address is returned to a C program?
  • Authentication in Play! and RestEasy
  • How to write order and limit within cakephp joins array
  • How to match http request and response using Jersey ContainerRequestFilter and ContainerResponseFilt
  • Fetching methods from BroadcastReceiver to update UI
  • Does CUDA 5 support STL or THRUST inside the device code?
  • Javascript + PHP Encryption with pidCrypt
  • jQuery tmpl and DataLink beta
  • Python: how to group similar lists together in a list of lists?
  • Proper folder structure for lots of source files
  • Understanding cpu registers
  • Qt: Run a script BEFORE make
  • How can I remove ASP.NET Designer.cs files?
  • python draw pie shapes with colour filled
  • Is there any way to bind data to data.frame by some index?
  • How can i traverse a binary tree from right to left in java?
  • Conditional In-Line CSS for IE and Others?