Question

how to read files when filenames and path are stored in another datasource (database)

  • 15 January 2019
  • 1 reply
  • 4 views

Hi everybody,

it seems to be an easy job, but at the end it is taking a lot of time to implement. I have patterns in my oracle database to access and read multiples Excel files, which contains several sheet.

When i access to this database, i get the filename, i cannot call directly the Reader for excel passing the name, sheet name and format.

 

I did some experiment with subroutines (like external calls) but it seems more complicated than expected. How can i read Excel files whose name is in the database without calling another workflow ? which is the logic standing behind this ?


1 reply

Userlevel 5
Badge +25

You can read the database with an Oracle reader, then run those features through a FeatureReader so you can construct the filename of the Excel file to be read using the attribute out of the Oracle database.

Reply