This project has moved and is read-only. For the latest updates, please go here.

Remote Open SQL Manager Quick Start Guide

Introduction

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.

Installation Instructions

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.

image

Click on Create and choose a function group where creating the new function module.

image

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.

image

Now you have to go to Attributes tab to change the function module Processing Type. Check Remote-Enabled Module.

image

Go to Source Code tab. Select all text and delete it.

image

Now go to Remote Open SQL Manager and select all text contained into Abap Code To Install tab.

image

Copy it and past it into Source Code. Then activate it.

image

Now you have completed the ABAP code installation of Remote Open SQL solution.

Creating a new destination

image

Go to Logon parameters tab.

Create a new destination and fill logon parameters.

image

Setting Options

Remote Open SQL Manager is able to export data into three type of files:

1. Text files

2. Excel Workbook

3. Access Database

image

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/.

Creating a new query

Go to Remote Open SQL Queries tab.

image

Create a new query, for example a query to select all fields and all records of MARA (General Material Data) table.

image

Actually the Remote Open SQL Grammar is under construction but you may see current syntax at Remote Open SQL Grammar tab.

image

From version 1.0.3.0 you may create queries with joins, column aliases and table aliases .

Start Query

Starting the query you will see subsequent screens:

image

image

image

image

image

When query is executed you may open resulting file clicking Open Query Result button.

Last edited Oct 6, 2011 at 9:27 PM by filippobottega, version 3

Comments

No comments yet.