Topic
2 replies Latest Post - ‏2012-05-23T15:42:34Z by DonH
DonH
DonH
9 Posts
ACCEPTED ANSWER

Pinned topic Getting Started - Connecting to remote DB2 databases

‏2012-05-15T11:11:10Z |
I just installed WEF v8 and intend to start using it after 3+ years of using IBM MashupCenter.
The initial tutorial is fine - I can create an application that connects to the local DB and displays the data.
My problem is now - "how do I acquire data from a remote DB2 database?"
I have tried creating a Connection Profile (File > New > Other > Connection Profile). The "Test Connection" completes ok but I cannot get any of the builders to "see" this connection profile as a datasource. Let's say I named it "RemoteTest".
I CAN create an SQL File using this connection as the datasource (File > New > Other > SQL Development > SQL File ).
I use the name of the connection profile that I created earlier (RemoteTest) and the result shows that I can connect to the remote DB2 database and build an SQL query for it. If I save the file (testSQL.sql) it can be run in the Developer framework and produces a list of DB entries.

So how do I get one of the SQL builders to see RemoteTest as a datasource? I've looked at all the builders but am failing miserably!
I'm willing to believe this is pretty fundamental but I just can't see it so far..

Can someone give me the kickstart to get me on my way please??

Thanks
Updated on 2012-05-23T15:42:34Z at 2012-05-23T15:42:34Z by DonH
  • mburati
    mburati
    420 Posts
    ACCEPTED ANSWER

    Re: Getting Started - Connecting to remote DB2 databases

    ‏2012-05-15T13:52:02Z  in response to DonH
    This appears to be a duplicate post.
    Please followup in the original thread at:
    http://www.ibm.com/developerworks/forums/post!reply.jspa?messageID=14824058
  • DonH
    DonH
    9 Posts
    ACCEPTED ANSWER

    Re: Getting Started - Connecting to remote DB2 databases

    ‏2012-05-23T15:42:34Z  in response to DonH
    this is a duplicate