Create an ETL to sync 3 Sharepoint Lists to SQL

$450-3750 MXN

Completed

Posted

over 7 years ago

$450-3750 MXN

Paid on delivery

We have 3 lists on a Sharepoint site (hosted inside our corporate network) that we need to sync to a similar SQL database (outside our corporate network). I have attached the 3 diagrams, and every time there is a new item (in the case of Sales Details and Forecast Details) or an update on an item (in the case of Product Requests) there should be a workflow that inserts the record on our SQL Tables. Our Sharepoint site has Nintex Workflows installed, if that could help. Please send your proposal explaining how you will solve the project, generic proposals will not be considered.

Nintex Workflow

Sharepoint

SQL

Project ID: 12812690

About the project

7 proposals

Remote project

Active 7 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@farrukhcheema23

hi, please accept it now and assign the project. thank you

$2,900 MXN in 10 days

4.9

(5 reviews)

3.9

7 freelancers are bidding on average $3,089 MXN for this job

@zahid629

There is no need to create workflow . It can be done on list event receiver . Each time item will be add in list then table will be update on Item Added event.

$2,333 MXN in 5 days

4.7

(10 reviews)

3.2

@ybautista

Hi, - I am a developer with extensive practical experience in Data Warehousing and Data Integration projects building ETL (Extract, Transform and Load) jobs using open-source tool 'Talend for Data Integration', which is a Java code generator tool that builds programs out of workflow and data flow designs. And I also know the challenges of automating the gathering and consolidation of several data sources (Web services, CSV, XLS) into a data warehouse. For this project, I can develop a master ETL job that will: - Connect to SharePoint using standard Talend SOAP components, or plain JDBC connection. - Poll for changes on each of your Sharepoint lists based on business rules, - Retrieve Updated/New items from each list, - Perform row transfomation and filtering if required, - Insert rows into target database tables, - Orchestrate all steps above. Deliverable will be a packaged Java program (JAR) that can be scheduled daily or even run on demand. Look forward to hearing from you. Kind regards, Yordan B

$3,500 MXN in 4 days

0.0

(0 reviews)

0.0

@SMDCompany

Our company is dedicated to the implementation of projects in SharePoint, the personalization and development of business solutions, for this we are the best candidate for this project.

$3,333 MXN in 20 days

0.0

(0 reviews)

0.0

@ntstchris

Dear Sir, We have read your job and we can provide you with the skills you require. We use to work to time lines and meeting clients' expectations with prompt communication. We have got more than 8 years of experience in IT Services. We have been involved in developing and managing Enterprise Solutions including SharePoint, CRM, ERP etc. for our clients. Some of our SharePoint clients are : 1. Adidas Group 2. Associated Foreign Exchange 3. iJento 4. Red 7 Marine 5. Retail Space Design 6. Housing Solutions 7. Arriva Should our proposal be of interest to you please do not hesitate to contact us to discuss this further. Kind Regards, Nimble Technology Solutions Team.

$2,333 MXN in 3 days

0.0

(0 reviews)

0.0

@reyesprada

Professional with experience in the development of BI solutions. Construction of datamart, construction of data warehouse. And creating ETL with SQL Server Integration Services. My solution is to make a package in ssis which connects to the list of sharepoint extract the data and save it in the table of the database

$3,333 MXN in 10 days