Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: How to connect oracle APEX with kettle(spoon)

  1. #1
    Join Date
    Dec 2013
    Posts
    4

    Default How to connect oracle APEX with kettle(spoon)

    Hi all,
    Need your help to connect kettle(data integration) with oracle 11g release2 APEX. I used JDBC to connect. But it ends up with "The Network Adapter could not establish the connection" error.
    Actually what i am trying to do is, to load data from excel to database table(no datas in it) created in APEX. always it throws the above error. Can anyone help me in this issue. Pleaseeee. I have attached Screen shot for your reference. PLEASE Help me.

    Thanks
    Reena
    Attached Images Attached Images   

  2. #2
    Join Date
    Jul 2009
    Posts
    476

    Default

    It looks like you have "SYSTEM" as the Host Name. That's probably wrong. If your database is local to your PDI machine, use localhost. If it's on another machine, use that system's DNS name or IP address.

  3. #3
    Join Date
    Dec 2013
    Posts
    4

    Default

    Thanks a lot robj. I made this silly mistake. thankyou one again.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.