Read XML files from remote server

Advertisement

Post Author: TomDegetel
CA Forum: Data Integration
This question may look simple to you but I don't see directly how to do this.The idea is to read data from an XML file which is sent to a UNIX directory on a server.When the JobServer is running on my local PC I can configure a flow that reads the file from the local harddisk but if the JobServer is running on another server I don't know how to reach this file.How can I connect from the jobserver to a remote server in order to read an xml file and read its contents into a query ? Thanks,  Tom

Advertisement

Post Author: bhofmans
CA Forum: Data Integration
you have several options :
1) Make sure the directory is accessible to your jobserver via shares. This can even be done between Windows and UNIX using SAMBA or related software.
2) Use ftp to get the file from the remote location and ftp it to a local drive (DI had built-in options to do ftp)
3) In 11.7 we added the possibility to specify an URL for the XML file in stead of a file name. So if you can make the XML file available via a web server on the UNIX machine, this would be another way to access the file.

November 30, -0001

Read XML files from remote server

Post Author: TomDegetel CA Forum: Data Integration This question may look simple to you but I don't see directly how to do this.The idea is to read data from an XML file which is sent to a UNIX directory on a server.When the JobServer is running on m

Problem  while reading XML file from Aplication server(Al11)

Hi Experts I am facing a problem while  reading XML file from Aplication server  using open data set. OPEN DATASET v_dsn IN BINARY MODE FOR INPUT. IF sy-subrc <> 0.     EXIT.   ENDIF.   READ DATASET v_dsn INTO v_rec. WHILE sy-subrc <> 0.   END

Reading XML file from application server and  put into internal table-4.6C

Dear All, Is there any way of reading XML file from application server to SAP? I am using 4.6C. Function module SCMS_STRING_TO_XSTRING function module is not available. Please suggest. Thanks and regards, AtanuHi Atanu! Simply use the XSLT transforma

FM to read XML files from Application server in ECC5.0

Hi All, We need to pick up an XML file from Application server/FTP server. The requirement is to parse the XML file and process it to create material master. SAP provides standard function modules to read XML files. Now we need to read the XML file c

Read XML file from different server on JSP

Dear All, I am a newbie to JSP with XML, now i want to read the "test.xml" from JSP. I read successfully this "test.xml" file from my system and I got output, but I need to read the xml file from different server like "http://www.

Upload xml file from aplication server using read dataset, parser error.

Hi, I would like to upload xml file from app. server but parser failed. If I upload this xml file from workstation (using ws_upload) it is correct. For uploading xml file from app. server I use open dataset... read dataset. In loop section I remove '

How to read the file from ftp server

Hi I need to read a file from a ftp server . Iam using apache lib common-net .jar . FTPClient ftp = new FTPClient(); ftp.connect(server); ftp.login(username,password); FTPFile[] files = ftp.listFiles(); for(int i=0 ;i<files.length;i++){ System.out.pr

How to read XL file from FTP server

Hi all, I have a requirement like to read file from FTP server using path ftp: 10.212......\DTR\DTR_ Accounted_Out and again save  other file in same location , to doing this RFC connection is required? give a  procedure or program to do this require

Using scp to copy files from remote server to mac from a newbie

Hi am a new poster to this forum and getting (re)acquainted with the unix world using terminal on the Mac. I am part of webteam for a large website run by a nonprofit where I have administrative access. I hope that this forum is the correct venue for

Help! Downloading a file from remote Server

I am currently doing a program for downloading a specified file from the remote server i.e from any website. If the downloading process stops in between due to some problem in the internet connection, then my program needs to start the downloading th

Reading XML file from java web service

Hi I am developing web service using Netbeans and the application server is glassfish. but I am facing a problem I have folder called "config" which will include the xml files. What I need to do setting path into that folder but it will read fro

Reading a file from ftp server

Hi I am able to put file on ftp server using ftp adapter.But same settings are not working while polling file on ftp. Do i need to do some settings for get operation??Hi, Check the file permissions and for testing give all read/write/execute permissi

Reading XML file from PL/SQL

Hi, I have a requirement where in I have to read email addresses from the xml file on the OS and use pass it on to a procedure as parameters. this is the xml file <?xml version="1.0" encoding="UTF-8" ?> - <V21> - <ToAddr

Reading XML file from package!!

HI, I have an xml file with two HIERARCHY levels with Global and local <global1> company</global1> <global2> address </global2> <global3>name </global3> <global4>position</global4> and -- *<loca1l/>* &

Read xml file from jsp/servlet

Hi all, I am a new comer to jsp and really appreciate if someone can help me on this: I will like to use a xml file to control access to my web app instead of using a database. Let say user.xml that will contains user name and password. Questions: 1.

Reading tab delimited file from application server

Hi All, I do know that we need to use Open data set to read a file from application server, but my question is when you use  read DATASET v_file into wa_final -  this wa_final is an work area and also i have mentione an internal table. so do we need

Reading an xml file from a jar file

Short question: Is it possible to read an xml file from a jar file when the dtd is placed inside the jar file? I am using jdom (SAXBuilder) and the default sax parser which comes with it. Long Question: I am trying to create an enterprise archive fil

Help on how to read the content of an XML file from the payload

I have a receiver channel / mail adapter, that sends e-mails with a XML attachment. I’m trying to write a Bean, that should make it possible to rename the attached XML file dynamically. In the Bean I want to read the content of the attached XML file,

Dynamically Reading Files From Application Server

Hi Experts, Presently I have to write a program which reads files from the application server dynamically. This program will be scheduled in the background with the frequency of half an hour. I am Using the function module CALL FUNCTION 'SUBST_GET_FI

Sending xml file from client to servlet

Hi, I am writing the server component of an applcation, such that it will receive xml files from the clients(standalone application similar to javaSwing stuff but it's coded in C#), and the servlet will have to extract the data from the xml file and