Forum Discussion

Siva_Venna's avatar
Siva_Venna
Contributor
7 years ago

Load .xlxb workbook with multiple sheets to oracle table. Load only one or specific sheet data only

I have .xlsx file on remote server. My requirement is to load the file content into an oracle table.
Any help is appreciable, Thanks in advance.

14 Replies

  • sriram's avatar
    sriram
    Former Employee
    7 years ago

    The easiest way to do this is to use a combination of these Snaps:

    File Reader > Excel Parser/Formatter > Oracle Insert

    The File Reader Snap supports reading data from a variety of remote systems.

    The Oracle Insert Snap can be used to load data from the upstream source into the Oracle table. Alternatively, for bulk data loading requirements, you could use the Oracle Bulk Load Snap

    • Siva_Venna's avatar
      Siva_Venna
      Contributor
      7 years ago

      Thank you sriram.
      I have gone through parameters of File reader snap, it supports different protocols but I had below query:
      a) server path I am accessing is like : \\Rsc.aaaa.com\rdrive\D00\AllDept\SHARED\ComRead\MA\2018
      in the snap Settings >File syntax is - ftp:// “path”
      I am giving as ftp:\\Rsc.aaaa.com\rdrive\D00\RRRRRR\SHARED\ComRead\MA\2018
      the snap is throwing error.
      b) There are many files in that path, I want to read only a single file and the name of file is dynamic(changes periodically but will have a specific pattern). I don’t find an option in the file reader snap to mention file name, please suggest on this

      • sriram's avatar
        sriram
        Former Employee
        7 years ago

        Are you attempting to access resources from an FTP server that has been mounted on a Windows server? And, is the error about authentication / connection failure? If yes, you will have to create a “Binary > Basic Auth” account and reference it in the File Reader Snap.