SQL iPlug
SQL iPlug : The complete integration of all your databases !
Use ORACLE, MySQL, MS SQL, MS Access, SYBASE… with RPG, CL, COBOL, PHP on System i – AS/400
No more platform barriers : SQL iPlug guaranties data sharing, transfer and conversion between your System i and your computer.
- Perfect integration: Integrate and share your data between all your environments (System i, Office…)
- Work with intelligence: No more long manipulations and complicated transfers ! Save time and money with increasing the productivity of your company.
Do not let the external servers replace the System i :
Integrate their data in your programmes and procedures !
SQL iPlug integrates the potentiality of your databases’ external servers in the System i applications. In a real time access to data and procedures (Read, Insert, Update, Delete, Call…).
Data extraction and treatment of your databases (SQL Server, DB2, Unix, Oracle…) in a single and unique solution !
SQL iPlug is a programming interface very easy to use, for all OS/400 languages: RPG, COBOL, CL, …
System i developpers do not have any training need to read and write in ORACLE, SQL Server ou MySQL.
A friendly and unique interface to take fast and pertinent decisions !
Nowadays, not every company’s data is stocked under DB2. The System i has to act on external databases, et to behave as every other platform.
With SQL iPlug, the native programmes are considered as clients by databases’ servers.
Through easy and fast methods, the developer accesses stocked procedures and tables. There is no need to rewrite code that already exist in an external database.
The System i fits into centralized services’ architecture
Your company can choose its management tools without worrying about execution platforms.
Information is always accessible and correct !
SQL iPlug eliminates replication and data synchronisation needs!
Fonctionalities
- Support the databases connection having ODBC driver.
MySQL, SQL Server, ORACLE, MS Access, MySQL, DB2, Excel …
- Access to the data for reading and writing.
- Support query statement with parameters, and immediate execution.
- Stored procedure support, with input and output parameters.
- Support multiple result sets on procedure exit.
- Security is checked with username and password.
- All types of query statements :
Select, Insert, Update, Call, Create, Commit, …
- The SQL data types are translated to and from AS/400 data types.
- Only TCP/IP link is required between the iSeries and Windows. No other middleware has to be installed.
- Service program is available for ILE programs.
|
| |
SQL iPlug is made of a library on the iSeries, and a server program to install on a Windows server or station. The programming interface is very easy to use. It allows to limit the amount of data exchanged between the iSeries and the target database to reach the best performances.
Technical features.
- Compliant with all OS/400 versions, since V4R2 .
- Accept all the programming languages : RPG, CL, COBOL, C, …
- Compliant with 4GLs.
- Programming interface available for ILE and non ILE.
- For batch and interactive jobs.
- Use only TCP/IP to connect to Windows.
|
| |
- Windows 95, 98, Me, 2000, NT, XP, 2003.
- Support all databases compliant with ODBC.
- SQL Server, ORACLE, ACCESS, MySQL, DB2, Excel, …
- Configuration in mode « Service » and « Desktop » mode.
- Use only TCP/IP to connect to the iSeries.
|
| |
- Prepare and execute statements with parameter markers.
- Read, Insert, Update data.
- Call stored procedure.
- Accept parameters in Input and Output.
- Convert all the SQL data types to OS/400 data types.
|
| |
|
PHP
