Remote Open SQL Manager Quick Start Guide
Remote Open SQL Manager is a GUI for the library RemoteOpenSQLLib.
The ROS Manager lets you organize connections and run queries remotely on SAP R/3 Application Servers.
To install the application run RemoteOpenSQLSetup.msi. Then run Remote Open SQL Manager.
Before using it you have to create a new function module named z_remote_open_sql.
To complete this task you have to connect to the target SAP R/3 application server using a SapGUI session.
To create the function module you may use SE80 or SE37 transactions. Remember to use a Developer user in a developer environment.
Type SE37 and fill the function module field with z_remote_open_sql.
Click on Create and choose a function group where creating the new function module.
If you want you may create the new function group and the new function module in $TMP (Locale) package. If you will transport the abap code to a production environment you will relocate code in another package.
Click save.
Now you have to go to Attributes tab to change the function module Processing Type. Check Remote-Enabled Module.
Go to Source Code tab. Select all text and delete it.
Now go to Remote Open SQL Manager and select all text contained into Abap Code To Install tab.
Copy it and past it into Source Code. Then activate it.
Now you have completed the ABAP code installation of Remote Open SQL solution.
Go to Logon parameters tab.
Create a new destination and fill logon parameters.
Remote Open SQL Manager is able to export data into three type of files:
1. Text files
2. Excel Workbook
3. Access Database
You may let all fields empty but if you want to download and open huge text files containing millions records I suggest you to use Large Text File Viewer at http://www.swiftgear.com/.
Go to Remote Open SQL Queries tab.
Create a new query, for example a query to select all fields and all records of MARA (General Material Data) table.
Actually the Remote Open SQL Grammar is under construction but you may see current syntax at Remote Open SQL Grammar tab.
From version 1.0.3.0 you may create queries with joins, column aliases and table aliases .
Starting the query you will see subsequent screens:
When query is executed you may open resulting file clicking Open Query Result button.