If I wanted to connect to a AS400 DBMS, what connector driver is it I’m supposed to use?. DB2 RazorSQL Create View with what is db2, install db2, db2 instances, db2 database, create database, activate database, deactivate database, connect to database, verify database, configure database manager, drop database, db2 bufferpool, drop bufferpool, db2 tables, create tables, list tables, insert data in table, db2 alias, db2 constraints, db2 indexes, db2 triggers, db2 sequences, db2.

IBM DB2 LUW 8.x, 9.x are the only IBM offerings on the support list as of August 2014Supported Migration Platforms These older threads show support for AS400 has been asked about as far back as 2011Sqldeveloper for DB2 on AS400 ISeries When I use the JTOPEN jar to connect to DB2 with RazorSQL, it works fine! I know I could use RazorSQL, but I would much prefer to use SQL Developer.Ĭan anyone point me in the right direction here to get it setup and working properly? I feel as if it's not looking for the driver in the proper location.Īs far as I know AS400 is still NOT supported. CData Software connectivity tools provide access to live DB2 data from popular BI, analytics, ETL, and custom applications, offering our customers access to their data wherever they want. A list of guides and tutorials for connecting to and working with live DB2 data. The error it gives is: 'Status : Failure -Test failed: Driver class not found. Automated Continuous SAP Concur Replication to IBM DB2. After I do that I get a DB2 tab when I open a new connection, but it won't accept my parameters. Built-in support for DB2, Derby/JavaDB, Firebird, FrontBase, HSQLDB, Informix, MySQL, OpenBase. I have downloaded the JTOPEN driver and placed it into a folder, and have added the jar file to the Third Party JDBC drivers list. Text to db2 download - Portable RazorSQL 9.4. It can connect to the database through ODBC and JDBC. For the time being, I would like to be able to connect to both databases in SQL Developer so that I can show some things to my employer. I have a v6.1 AS400/DB2 at my workplace that we are currently looking at migrating to an Oracle database.

Razorsql and connect to db2