Create an ETL to sync 3 Sharepoint Lists to SQL

$450-3750 MXN

Concluído

Publicado

há mais de 7 anos

$450-3750 MXN

Pago na entrega

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

ID do Projeto: 12812690

Sobre o projeto

7 propostas

Projeto remoto

Ativo há 7 anos

Quer ganhar algum dinheiro?

Endereço de e-mail

Benefícios de ofertar no Freelancer

Defina seu orçamento e seu prazo

Seja pago pelo seu trabalho

Descreva sua proposta

É grátis para se inscrever e fazer ofertas em trabalhos

Concedido a:

@farrukhcheema23

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

$2.900 MXN em 10 dias

4,9

(5 avaliações)

3,9

7 freelancers estão ofertando em média $3.089 MXN for esse trabalho

@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 em 5 dias

4,7

(10 avaliações)

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 em 4 dias

0,0

(0 avaliações)

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 em 20 dias

0,0

(0 avaliações)

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 em 3 dias

0,0

(0 avaliações)

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 em 10 dias