ETL of txt & excel files and ASP.net Website (C#, ASP.net EF)
$30-250 USD
Paid on delivery
Configuration driven ETL
1. Application is divided into two groups.
a. ETL console application.
b. ASP.net Core Web application for configuration.
2. ETL Console application.
a. Application read configuration (mappings) from database.
b. Configuration defines Path of file (local server path with pattern example c:/temp/[login to view URL]), type of file (.txt, .csv, .xls, .xlsx ) columns in the file and mapping of those columns to the internal table.
c. Internal there could be one or more table for each file, that is defined in mappings( config) in the database.
d. Table Strucuture will be like this.
i. ETLConfig( High level import mappings)
ii. ETLExecutions(reference ETL Config) one entry with each execution of the results( if fail or success)
iii. ETLMappings( reference ETL config), this defined, File columns name mappings to Internal table mappings
e. For import files,
i. Excel: File could have column headers or not.
ii. Txt file: delimiter could be comma (,), tab (/t), pipe (|) or anything else, should be defined in ETL Config. First row could be Header or not, should be defined in the ETLConfig, any other import file configuration should be defined in ETLconfig table.
3. ASP.net Application:
a. This application will be used to define ETL Configuration, ETL Mappings and review ETLExecution Results.
b. ASP.net core logins. There will be 3 Roles. SuperAdmin( who can manage other admins).
c. Admin who can add/update/delete ETL Config and Mappings.
d. Users: who can review data of all tables?
4. Entity Framework 6(Code first) will be used by both ETL and ASP code.
Note: Feel free to use any open source library. (Should be open source not licenses and common library, nothing unknown)
Expected minimum technology to use
C#, ASP.net core, EF, Automapper, log4net
Project ID: #11547089
About the project
20 freelancers are bidding on average $199 for this job
Hello Sir, I have gone through your requirements regarding ETL of txt & excel files and ASP.net Website (C#, ASP.net EF). we brief and understand your idea and preference for job as you are looking for. I have mo More
Hello, We are expertise Team of Professionals having experience of more than 12+ years in IT Fields. We have very good exposure in .NET, WCF/WPF, MVC 4+, MSSQL, LAMP, PHP, MySQL, Wordpress, CakePHP etc.., We ar More
I am sure I can help you with this. Please let me know if you'r interested so we can discuss the details and the help you need.
I'm software developer and I've experience in developing web and desktop apps apps using .net framework,C#, Asp.net, html, css, javascript and jquery. In addition to that I'm very good at sql databases
Hello, KRTS TECH is a Software Company located in Houston, TX. We have 10+ years of experience in .Net and DB Programming. We will deliver the best work to meet your requirements. Regards,
Hello! I have Informatica(licensed ETL tool) already installed in my system. Let me know if I can be a part of the team. My cell number : +91 9664762039. Thanks
We are a web design and development company dedicated towards micro and small entrepreneurs, small and large organizations using, web tools such as Dreamweaver, Photoshop, Corel draw, Illustrator with techniques of HTM More