1 / 9

Native SQL, Agent-less access to Oracle, MS-SQL, MySQL, Excel & other data sources

DB-Gate: IBM i Remote Database Access. Native SQL, Agent-less access to Oracle, MS-SQL, MySQL, Excel & other data sources. When an i application requires integration of data with any other database…. MS SQL. MySQL. Oracle. SQLite. IBM i. Excel CSV.

chyna
Download Presentation

Native SQL, Agent-less access to Oracle, MS-SQL, MySQL, Excel & other data sources

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