Extract xml from OTM

[Stefano]

Hello guys,
anybody knows how to have a transmission xml standard file OUT from OTM on same machine of APP server in a directory, without having possibility to use FTP because customer policy block ANY FTP TRANSMISSION

I'm able to produce, using external system, a file in the transmission table on DB, before to implement a dedicate PL/SQL to extract from DB, there is any other opportunities

thanks in advance.

[chrisplough]

Re: Extract xml from OTM

Stefano,

The only other way I can see to do this is to utilize a stock Apache server to accept posts and write to disk via a CGI program and then have OTM send integration to it via http posts. The two most common OTM outbound integrations are http and ftp, so if ftp is blocked...

Also, since this is on the same app server, just in a different directory, firewall rules shouldn't matter, since everything will be transferred via localhost (127.0.0.1) and avoid the network interfaces.

--Chris

[Stefano]

Re: Extract xml from OTM

Thanks Chris,
Infact I explore "http servlet" world try to find a "already done" solution to use and looking...looking .....I find several servlet but really not complete....and finally....



OTM utilities are the answer!!!!!!

If you look in utils directory you find a pyhton script that work very fine, is a HTTP listener on configurable port, that discard file in a directory that could be a parameter of the url.
SO if you need to EXTRACT OUT from OTM XML TRANSMISSION IN AUTOMATIC WAY without a FTP connection available U could use pyhton script HTTPFileCatcher.py in $GLOG_HOmE/utils/integration/python....read in it all instrunctions....

I hope that this could helpful for others I lost a lot of my "ZZZzzz" on it...

regards.

[chrisplough]

Re: Extract xml from OTM

Stefano,

Thanks for mentioning this. I definitely agree and often recommend these Python scripts. They provide a great way to do inexpensive integration and to also utilize for other purposes (like your case).

Again, thanks for mentioning, since I forgot to.