how can Datastage connection to the Portal to extract data from SAP portal information. It is a web-portal from where certain data is of the project's interest for mapping business logic.
While I asked them if there is a back-end Database to the portal, DataStage can connect via DB connectors and extract data, I was asked by the portal owner if and how 'Datastage connects to a J2EE Engine'.
I see a Java Client and a Java Transformer Under Real Time, but nothing related to Java Pack under Packs in the Palette.
Is this for purchase or can be requested from IBM?
Does the Java Client and Java Transformer has the ability to extract data from a portal(J2EE)? I looked through the documentation and it looks like a real time stage(pass something to it, using this value, the Plug-in will fetch a matching record from the source) but if my requirement is to extract all the information like a (select a,b,c from tableD), is this the right stage/pack to use?
Is there a turn around solution or a mitigation for this. I can request for a file feed from the Portal team, but I am trying to reduce the handshake between systems.
From what little I've read, a "J2EE Engine" supports ODBC access. You may end up needing to purchase the drivers needed but I would think you could go that route.
-craig
"You can never have too many knives" -- Logan Nine Fingers