IBM i Global

IBM i Global

Connect, learn, share, and engage with IBM Power.

 View Only

  • 1.  Help for data source driver for RPG programs of System i accessing external DB

    Posted Tue June 20, 2023 10:17 AM
    Edited by JIE LIU Tue June 20, 2023 10:33 AM

    HI,

    I'd like to enable RPG programs on System i to access external DB (Access, MySQL, Oracle etc) directly. Is it available for system i?

    • Where to get the data source driver (like ODBC, JDBC) to achieve the target to access external DB.
    • How to configure the connection for the driver?

    If there is no driver available to acess external DB directly, is there any other solution?

    Many Thanks

    Jie Liu

    ------------------------------
    Jie Liu
    ------------------------------



  • 2.  RE: Help for data source driver for RPG programs of System i accessing external DB

    Posted Wed June 21, 2023 11:05 AM

    Hi,
    this is possible. Have a look to Dieter Benders "ardgate"

    Link: https://sourceforge.net/projects/appserver4rpg/



    ------------------------------
    [Karl] [Fritz]
    [sr. Consultant]
    ------------------------------

    Original Message


  • 3.  RE: Help for data source driver for RPG programs of System i accessing external DB

    Posted Wed June 21, 2023 11:43 AM

    The most „application transparent" would be the use of a DRDA connection. This is the same protocol and method that DDM-files use, for database connections between two IBM i systems/partitions. 

    AFAIK there are products for Microsoft's SQL Server and Oracle available. And of course for DB2. Maybe there are other, that I don't know. 

    Just search for "DRDA" (Distributed Relational Database Architecture). 

    HTH



    ------------------------------
    Daniel Gross
    ------------------------------

    Original Message


Related Content