Create an Application or SSIS Package to Sync ERP with Dynamics CRM

Create either a standalone application or SSIS package that will update the CRM account data using the following logic:

1. If account number matches between CRM Account and ERP Account, update account name, address1, address2, address3, city, state, zip, and phone.

2. If account number is empty in CRM, attempt to match based on account address1, city, state and zip. If a match is found, update account name, account number, address2, address3, and phone.

3. If no match is found in CRM for the ERP account, create it and assign the owner as "SYSTEM IMPORT."

The ERP data is available via an MSSQL view.

The CRM system is Dynamics CRM 2016 hosted on premise with IFD.

The SSIS package must not be dependent on any other licensing (such as Kingsway Soft).

The application/SSIS package must be capable of running on a scheduled basis without user interaction.

Skills: Microsoft SQL Server

See more: dynamics crm create, create case support queue dynamics crm, dynamics crm create case email, microsoft sql server, create install package application, create customer portal dynamics crm 2011 online, set sync magento dynamics crm online api, dynamics crm api create invoice product, dynamics crm sdk create invoice, create invoice dynamics crm 2011, create web service microsoft dynamics crm, create outlook crm sync vbnet, freelancing dynamics crm projects, dynamics crm asterisk, dynamics crm projects, javascript dependant picklist dynamics crm

About the Employer:
( 16 reviews ) Oakfield, United States

Project ID: #14336781

16 freelancers are bidding on average $197 for this job


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 hav More

$200 USD in 7 days
(55 Reviews)

MM. I will create the SSS package for these 3 cases. please let me know the package will deal with only one table(account info) Thanks. Relevant Skills and Experience MSBI, SSIS, SQL Proposed Milestones $100 USD - fi More

$166 USD in 3 days
(19 Reviews)

I have worked with CRM SDK and CRM sql database before in several projects and I can develop a standalone application to do what you are trying to do. Relevant Skills and Experience I have more than 5 years of profess More

$250 USD in 6 days
(9 Reviews)

Please review my profile. Relevant Skills and Experience I have 7.5 years experience in SQL and 4.8 years experience in SSRS, SSIS. Proposed Milestones $130 USD - SSIS Package to Sync ERP with Dynamics CRM Please le More

$130 USD in 0 days
(9 Reviews)

experience 10 years in .net and ms sql server database development

$220 USD in 10 days
(4 Reviews)

Hello swansonm I can complete your task using SSIS package or C# standalone App Relevant Skills and Experience I have solid experience in .NET framework apps (web and windows) and SQL server SSIS, SSRS Proposed Mile More

$133 USD in 2 days
(2 Reviews)

We can achieve the desired functionality through SSIS or a console application, which can be scheduled. Relevant Skills and Experience 5+ years of experience. Dynamics CRM specialist, expert of SSIS, Scribe and custom More

$555 USD in 7 days
(1 Review)

Dear Employer , we are experts in Microsoft BI stack , SQL Server ,C# , ASP.Net . we work for Microsoft as consultants and this is first time we are entering into the freelancing world. we are good at data entry proje More

$100 USD in 3 days
(0 Reviews)

I think that with 3 days I can finish... if you have the analysis of the database I can do some quickly.

$220 USD in 3 days
(0 Reviews)

Hi, This is bharathi from India. Having 6 years of experience in MSSQL, MSBI. I would like to start work as a freelancer. If you ok with my profile am ready for interview. Am sure i will work sincere and finish the pro More

$155 USD in 3 days
(0 Reviews)

Microsoft dynamics crm senior specialist more than 10 year of experience Specialist in integration between dynamics crm and other system: Erp sales forces sap oracle seibel... Crm 2016-2015-2013-2011 Dynamics 365 Ssis More

$250 USD in 1 day
(0 Reviews)

A proposal has not yet been provided

$200 USD in 10 days
(0 Reviews)

I have very well experience in developing ssis packages and sql server.

$111 USD in 2 days
(0 Reviews)
$222 USD in 5 days
(0 Reviews)

A proposal has not yet been provided

$91 USD in 2 days
(0 Reviews)
$155 USD in 3 days
(0 Reviews)