Simple ETL website with dynamic mapping between source and destination.

[Aown Muhammad]

Hi,

I looking for a tool to develop a web application for client. The web site will populate financial data from different sources manly excel sheets.

The use case is user will log into web application upload excel file and select target table to load. User will then specify mappings of columns between source (which is excel) and target(which is database table). After specifying the mapping user will press finish to load the column.

Is it possible to handle this scenario of dynamic mapping using Rhino ETL?

If yes kindly guide me which classes need to be used to accomplish this task?

[Nathan Palmer]

Hello Aown,

This is definitely possible. You'd need to write custom operations though to achieve it. We do something similar except we automap data coming from sql stored procedures out to csv text files. Regardless of the input columns and types the export gets created. Sounds like you'll have a user do the mapping so all of that would need to happen ahead of time and outside of Rhino Etl (since we're dealing with the UI at that point.) I'd see it going something like this

DynamicExcelOperation

   * constructor pulls in the fields that the user specified and initializes an object that can read from excel docs

   * I can't help on excel libraries though since I don't use any of them today

SqlBulkInsertOperation

   * constructor pulls in the mapping fields just like excel

   * initializes the mapping for the columns based on what the user had entered

Process.Execute()

Nathan Palmer

--
You received this message because you are subscribed to the Google Groups "Rhino Tools Dev" group.
To unsubscribe from this group and stop receiving emails from it, send an email to rhino-tools-d...@googlegroups.com.
To post to this group, send email to rhino-t...@googlegroups.com.
Visit this group at http://groups.google.com/group/rhino-tools-dev.
For more options, visit https://groups.google.com/groups/opt_out.

[Aown Muhammad]

Thanks Nathan. i will move forward with Rhino ETL in this case.