1 / 9

Seamless Remote Database Access on IBM i - DB-Gate by Raz-Lee

DB-Gate by Raz-Lee offers agent-less access to Oracle, MS SQL, MySQL, Excel, and more from IBM i. Unlike conventional methods requiring middleware or complex APIs, DB-Gate provides a straightforward solution that operates natively on IBM i, utilizing familiar SQL commands like STRSQL and CRTSQLxxx. It integrates seamlessly with Host Server Authentication and supports multiple database sources without additional hardware or software. Simplify your database integration today and experience the freedom of choice with DB-Gate's innovative, patent-pending solution.

chyna
Télécharger la présentation

Seamless Remote Database Access on IBM i - DB-Gate by Raz-Lee

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. DB-Gate: IBM i Remote Database Access Native SQL, Agent-less access to Oracle, MS-SQL, MySQL, Excel & other data sources

  2. When an i application requires integration of data with any other database… MS SQL MySQL Oracle SQLite IBM i Excel CSV

  3. You have the freedom of choice to run it on any platform except the i. This is because the i cannot “connect” to other databases, but they all can ODBC to the i ! Excel CSV Oracle MySQL MS SQL SQLite

  4. Oh yes - you can use a complex customized solution based on FTP, use a product that requires a middleware server, or write complex non standard APIs, …but why? Now you have an alternative… FTP HW SW API IBM i MS SQL Oracle MySQL SQLite ExcelCSV

  5. MS SQL Oracle MySQL SQLite FTP HW SW DB-Gate API ExcelCSV Raz-Lee’s DB-Gate (patent-pending) requires no API, no HW/SW server, and it runs native on the i, including STRSQL, and CRTSQLxxx, and even integrates with Host Server Authentication

  6. COBOL / RPG / C STRSQL *...1....+....2....+....3... C/EXEC SQL C+ DECLARE C1 CURSOR FOR C+ SELECT * FROM CORPDATA.DEPT C+ WHERE JOB = 'MANAGER' C/END-EXEC Enter SQL Statements > SELECT * FROM PROD.CUST > CREATE VIEW CORPDATA.MANAGERS AS SELECT LASTNAME, DEPT FROM CORP.EM WHERE JOB = 'MANAGER' > DELETE FROM PROD.CUST WHERE ID = 78 ===> ________________________________

  7. Utilizes standard SQL statements Works from all native SQL commands (STRSQL, RUNSQLSTM)

  8. Integrated with IBM Host Server Authentication (eliminating repetitive User/Pwd) F4=Prompt will display remote table columns

  9. Thank You! Please visit us at www.razlee.com marketing@razlee.com 9

More Related