How to fetch data from Non-sap system tables

[Former Member]

Hi All,

Without using any middleware and not the IDOC too..

Can i fetch data from the non-sap system(EPIC). Please let me know solutions.

[Former Member]

Hi,

You can use FTP to put data on UNIX directory from EPIC and then read in program using OPEN data set command and then process data.

OPEN DATASET gv_zarc FOR INPUT IN TEXT MODE ENCODING DEFAULT.

Is that you are looking for?

thnx,

ags.

[Former Member]

Hi Ags,

As per my requirement in need to write a program in SAP.

So that it goes to EPIC system and pulls data from a table and i need process those records in SAP and i need update the status of those records and update back the EPIC table with modified status.

And i have no idea how to start it. can you explain me briefly.

Edited by: keerthipati hemanth on Jun 4, 2008 4:52 PM

[GrahamRobbo]

Hi Kerry,

if the external database is one that is supported by SAP, this means SAP will run on it, you can connect directly to it from your SAP WAS using a technique called DB Multi Connect.

Look in OSS for some notes on how to do this, also in the SAP Help.

Essentially you need to install the database-specific portiion of the SAP kernel that supports the external database. You also need to install the database client software so the SAP server can remotely connect to the external database.

Then in transaction DBCONN you define the external database connection.

Once this is done you can use native SQL to directly interact with the external database.

Cheers

Graham Robbo

[Former Member]

Requirement is no long needed

[Former Member]

Requirement is no long needed