0 Replies Latest reply: Mar 21, 2012 11:28 AM by 898139 RSS

    Mainframe Sequential Files Topology Connection

    898139
      I am trying to connect to Mainframe to read a flat file and load into an oracle table. What should be topology connection. I tried Files technology not working.

      Driver:com.sunopsis.jdbc.driver.file.FileDriver
      URL:jdbc:snps:dbfile

      Created a Dataserver under files. In Host i have provided the ip address. under the connection have provided the userid and password.
      When creating the physical schema i did not provide any directory as mainframe does not support any.

      I created a file model which has one column with 80 chars. Built an interface to move this file to an oracle table with one column 80 chars and am facing issues.

      Error
      ODI-1227: Task SrcSet0 (Loading) fails on the source FILE connection FILE_HOST1.
      Caused By: java.sql.SQLException: File not found: /DEV.COGU119.OUT

      To ovoid this changed the /dataset name changed the naming rules under the physical schema to just %OBJECT. After this I am getting this error.

      ODI-1227: Task SrcSet0 (Loading) fails on the source FILE connection FILE_HOST1.
      Caused By: java.sql.SQLException: File not found: DEV.COGU119.OUT

      Should I be using a different driver if so what and where can i get it. Thanks in advance.

      Rams.

      Edited by: Rams on Mar 21, 2012 9:27 AM