Ditutup

Automatization of data import Microsoft SQL

READ THIS FIRST!!!

Ok. We are building an .ASP NET webshop.

The webshop will have its own Microsoft SQL Database (DB1) for its own products.

The owner has a contract with a third party dropshipper who has +100K products, the dropshipper delivers a URL from where we can pull the product feed.

We want a second database (DB2) which will hold all products imported from the dropshipper.

In our illustration (see attachment) you can see the setup.

We want the dropshipper (illustrated as DB3) to communicate with DB2 and update itself daily automatically where it will add new products, update stock and prices etc.

I need someone who can make the connection and automation between DB2 and the dropshipper + the automatic updates. Keep in mind that the productfeed comes with more columns then we need, so it has to automatically map the columns we need and disregard the ones we dont.

see picture and reply only if you have read the case!

Keahlian Pengembangan Database, Pemrograman Database, Teknik, Microsoft SQL Server, SQL

Lihat lebih lanjut: import data to mysql table and make some calculations post the values to database, import data to mysql table and make some calculations + post the values to database, sql server import data excel, sql job import data, sql script import data, sql 2005 import data csv existing table, sql express 2005 import data csv, import data sql txt, import data sql database using fifo, import microsoft project data excel, quickbooks import data sql server, import data csv file sql 2005, sample code import data sql server, sql ssis import data, import data access sql script, import data access sql

Tentang Pemberi kerja:
( 3 ulasan ) The Hague, Netherlands

ID Proyek: #11735837

35 freelancer menawar pada rata-rata $208 untuk pekerjaan ini

mpalgeo

Hi I have been working with MSSQL for over 17 years. I am fully experienced as a developer and a DBA. Currently I am working at big financial organization in which I am responsible for the BI department. I have Lagi

$200 USD dalam 5 hari
(54 Ulasan)
6.0
SKJoy2001

Good morning. If I am not wrong, you just need a system where the DropShipper (DB3) data will be pulled in, analyzed against existing DB2, new items will be added & existing items will be updated with a DB3 => DB2 f Lagi

$198 USD dalam 3 hari
(59 Ulasan)
5.6
vlad70

Dear Sirs, as freelancer Concentrate on database and ETL related projects for ETL projects I use Talend Open Studio - universal and open source solution (community and subscription + cloud versions available ) p Lagi

$500 USD dalam 5 hari
(34 Ulasan)
5.6
fanninson45

INTRODUCTION We have done a similar project like this recently for a Canadian Sporting Organisation here [url removed, login to view] SHOWCASE An experienced Microsoft Certified Pro Lagi

$155 USD dalam 3 hari
(10 Ulasan)
5.3
ashupathania

I have 5 + years of experience in MSBI Technology (SQL Server 2008/2012, SSIS, SSRS, and SSAS) Worked with the reputed clients like Microsoft, HCL, and Dicks Sporting Goods etc. Worked on various types of ER diagram Lagi

$500 USD dalam 3 hari
(32 Ulasan)
5.1
point5nyble

Hello, I have been working with a MNC based company since last ~ 6 years, as an IT BI DWH Professional. The project is a BI DWH project which covers 3 layers of BI (ETL, Data warehouse & Reporting) and helped me Lagi

$233 USD dalam 3 hari
(32 Ulasan)
4.8
nikmah344

Hello, I have read through the job details extremely carefully and I am absolutely sure that I can do the project very well. I have provide same solution where DB(SQL server) has to be updated through some regula Lagi

$166 USD dalam 5 hari
(28 Ulasan)
4.7
DeoTech

I am a database developer with 17 years experience in MS SQL. Your task is a clear for me. I have many project in the past, like yours. For example getting via ftp zip file, upload 20 000 000 rows, price, stok, Lagi

$222 USD dalam 3 hari
(15 Ulasan)
4.5
Astalavist4

Hi, I can do this for you. Few questions .1. Do you own the server for DB2? Can I create my own program that will be scheduled and it will call the doorshipper database and update DB2. I will create Lagi

$155 USD dalam 3 hari
(14 Ulasan)
3.9
crypthne

I have bachelor and master degrees in IT. My Primary skills include Java, Python, VB/.NET, ArcGIS, and PHP. Also database skills include MS Access, MySQL, and Oracle. My Other skills include server and network administ Lagi

$222 USD dalam 7 hari
(8 Ulasan)
3.2
WeazenSoft

Hello Respected Sir/Madam, We have a team of Microsoft Certified Solution Developer (MCSD) and Design & Development and I have more than 7 years experience in software development and web development using Microsoft Lagi

$200 USD dalam 10 hari
(6 Ulasan)
2.7
AHTOAH

Hello, I'm a .NET programmer with great experience in MS SQL related automation solutions. I have read the description of your project and the problem that needs to be solved and I'm ready to create the required so Lagi

$150 USD dalam 4 hari
(4 Ulasan)
2.3
jgenato2

Hi, I've read your requirement and it seems that you need a background processing in getting the data from xml, csv or url. For this, I suggest that we use a windows service that will serve as a middle man between a Lagi

$277 USD dalam 5 hari
(2 Ulasan)
1.9
tridentsynergies

Dear Project Owner, I have a few questions about your project: 1. You mentioned DB1 as MSSQL database- is it the case with DB2 and DB3 ? 2. How many tables are we planning to pull from DB2 to DB3, and what is the ave Lagi

$100 USD dalam 10 hari
(1 Ulasan)
1.3
OrangeTechsol

Hello Sir, We have client from netherland whom we give 24/7 support in Database. We would happy to share the details of that client. I understood that you are looking for expert Database developer for your project. Lagi

$166 USD dalam 4 hari
(1 Ulasan)
1.5
$200 USD dalam 5 hari
(1 Ulasan)
0.8
jeffersongraa

Hi, how are you? I'd like to do this job because I have experience in integrating platforms, either api or web service. In your case I thing we can build a service capable to do it. tks

$250 USD dalam 3 hari
(0 Ulasan)
0.0
assuranceES

To learn more about me please search my name Khalid Hussain, MBA in linkedin. It will explain my vast experience..

$250 USD dalam 10 hari
(0 Ulasan)
0.0
$155 USD dalam 3 hari
(0 Ulasan)
0.0
SoftIntelligence

Hi my name is Alex i am looking for job for long collaboration. I have 10 years experience C#.NET and dozens of completed projects. I am ready for resolve test task free for confirmation my experience. WEB FORMS or Lagi

$155 USD dalam 10 hari
(0 Ulasan)
0.0