Find Jobs
Hire Freelancers

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

$30-250 USD

Mbyllur
Postuar almost 7 years ago

$30-250 USD

Paguhet në dorëzim
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.
ID e Projektit: 14336781

Rreth projektit

16 propozime
Projekt në distancë
Aktive 7 yrs ago

Po kërkoni të fitoni para?

Përfitimet e ofertës për Freelancer

Vendosni buxhetin dhe afatin tuaj
Paguhuni për punën tuaj
Përshkruani propozimin tuaj
Është falas të regjistrohesh dhe të bësh oferta për punë
16 profesionistët e pavarur ofrojnë mesatarisht $197 USD oferta për këtë punë
Avatari i Përdoruesit
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 designed and the Developed the Organization’s Reporting Database which has been constructed with SQL Server 2008 R2 Enterprise Edition. The database is being updated daily from the core system with txt or excel files via SSIS or with direct connection at mainframe’s DB2 and a numerous of KPIS are being daily updated during the ETL. For isolation reasons the KPIS are replicated to another DB (with transactional replication) which exploits dashboards via Power BI and reports via SSRS to the consumers. Some KPIS are being replicated with merged (bidirectional) replication. Also, 10 Cubes in SSAS are being daily automatically processed and the end of the ETL. Several other reports are daily automatically produced and sent via email to the recipients. Finally I have designed and developed the bank’s crm DB which is published on the intranet. The DB holds full information about the customers (Customers,Addresses , Financial Data , Contacts , campaigns , etc) and covers 4 countries. To achieve this i have made partitions over the country code. The size of the Reporting DB, is about 4TB and consists of about 4.000 objects and the replicated KPI DB is 350GB. Best Regards mpalgeo
$200 USD në 7 ditë
4,9 (55 përshtypje)
5,8
5,8
Avatari i Përdoruesit
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 - first $66 USD - final Please give me more details
$166 USD në 3 ditë
4,7 (19 përshtypje)
4,7
4,7
Avatari i Përdoruesit
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 let me know more details and when we will start. Sky pe: jikenjd
$130 USD në 0 ditë
5,0 (9 përshtypje)
3,3
3,3
Avatari i Përdoruesit
experience 10 years in .net and ms sql server database development
$220 USD në 10 ditë
5,0 (4 përshtypje)
3,0
3,0
Avatari i Përdoruesit
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 Milestones $133 USD - complete task
$133 USD në 2 ditë
5,0 (2 përshtypje)
1,8
1,8
Avatari i Përdoruesit
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 apps for data migration. Proposed Milestones $555 USD - Project Lets discuss it in detail.
$555 USD në 7 ditë
5,0 (1 review)
2,0
2,0
Avatari i Përdoruesit
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 projects and filling forms or websites. we are certified from Microsoft in SQL Server , Oracle ,MSBI. we want to make our foot prints so strong in freelancing world and we need a opportunity to prove our self. we have completed 3 projects successfully and looking forward to work with you. Looking forward to hear from you. Please feel free to ping us.
$100 USD në 3 ditë
0,0 (0 përshtypje)
0,0
0,0
Avatari i Përdoruesit
I think that with 3 days I can finish... if you have the analysis of the database I can do some quickly.
$220 USD në 3 ditë
0,0 (0 përshtypje)
0,0
0,0
Avatari i Përdoruesit
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 project on time with good quality. Thanks, Bharathi Kannan. R +91 9500070776
$155 USD në 3 ditë
0,0 (0 përshtypje)
0,0
0,0
Avatari i Përdoruesit
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 biztalk smartconnect .net crm sdk
$250 USD në 1 ditë
0,0 (0 përshtypje)
0,0
0,0
Avatari i Përdoruesit
A proposal has not yet been provided
$200 USD në 10 ditë
0,0 (0 përshtypje)
0,0
0,0
Avatari i Përdoruesit
I have very well experience in developing ssis packages and sql server.
$111 USD në 2 ditë
0,0 (0 përshtypje)
0,0
0,0
Avatari i Përdoruesit
A proposal has not yet been provided
$91 USD në 2 ditë
0,0 (0 përshtypje)
0,0
0,0

Rreth klientit

Flamuri i UNITED STATES
Oakfield, United States
5,0
16
Mënyra e pagesës u verifikua
Anëtar që nga korr 22, 2013

Verifikimi i klientit

Faleminderit! Ne ju kemi dërguar me email një lidhje për të kërkuar kredinë tuaj falas.
Ndodhi një gabim gjatë dërgimit të email-it tuaj. Ju lutemi provoni përsëri.
Përdorues të regjistruar Punë të postuara
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Po ngarkohet shikimi paraprak
Leja u dha për Geolocation.
Seanca e hyrjes ka skaduar dhe ke dalë. Hyr sërish.