otmfaqForumsBlogsRegister
FAQMembers ListCalendarToday's PostsSearch


 Subscribe Blogs:RSS
 Subscribe Forums:RSS
OTMFAQ Home
OTMFAQ Blogs
OTMFAQ Forums
OTMFAQ Tutorials

OTM SIG
MavenWire


Integration and Data Mapping Integrating OTM / G-Log with external and legacy systems - including XML, WebServices, SOA, ESB, BPEL, EDI and Oracle's Fusion.

Reply
 
Submit Tools LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old April 10th, 2008, 13:31
Junior Member
 
Join Date: Mar 2007
Location: Italy
Posts: 27
Thanks: 4
Thanked 5 Times in 5 Posts
Groans: 0
Groaned at 0 Times in 0 Posts
Rep Power: 0
Stefano is on a distinguished road
Send a message via MSN to Stefano Send a message via Skype™ to Stefano
Extract xml from OTM

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.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old April 17th, 2008, 06:39
chrisplough's Avatar
Site Moderator
 
Join Date: Jun 2006
Location: West Chester, PA
Posts: 785
Blog Entries: 7
Thanks: 49
Thanked 193 Times in 118 Posts
Groans: 0
Groaned at 0 Times in 0 Posts
Rep Power: 10
chrisplough has a spectacular aura aboutchrisplough has a spectacular aura aboutchrisplough has a spectacular aura about
Send a message via AIM to 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
__________________
Chris Plough
MavenWire

www.MavenWire.com
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old April 17th, 2008, 07:45
Junior Member
 
Join Date: Mar 2007
Location: Italy
Posts: 27
Thanks: 4
Thanked 5 Times in 5 Posts
Groans: 0
Groaned at 0 Times in 0 Posts
Rep Power: 0
Stefano is on a distinguished road
Send a message via MSN to Stefano Send a message via Skype™ to Stefano
Thumbs up 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.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
The Following User Says Thank You to Stefano For This Useful Post:
chrisplough (April 17th, 2008)
  #4 (permalink)  
Old April 17th, 2008, 07:50
chrisplough's Avatar
Site Moderator
 
Join Date: Jun 2006
Location: West Chester, PA
Posts: 785
Blog Entries: 7
Thanks: 49
Thanked 193 Times in 118 Posts
Groans: 0
Groaned at 0 Times in 0 Posts
Rep Power: 10
chrisplough has a spectacular aura aboutchrisplough has a spectacular aura aboutchrisplough has a spectacular aura about
Send a message via AIM to 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.
__________________
Chris Plough
MavenWire

www.MavenWire.com
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply



Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT. The time now is 19:16.
Copyright © 2008, Open Book Solutions LLC. All rights reserved.

Sponsored by MavenWire - MavenWire.com


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37