Find Jobs
Hire Freelancers

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

$30-250 USD

Cerrado
Publicado hace casi 7 años

$30-250 USD

Pagado a la entrega
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 del proyecto: 14336781

Información sobre el proyecto

16 propuestas
Proyecto remoto
Activo hace 7 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
16 freelancers están ofertando un promedio de $197 USD por este trabajo
Avatar del usuario
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 en 7 días
4,9 (55 comentarios)
5,8
5,8
Avatar del usuario
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 en 3 días
4,7 (19 comentarios)
4,7
4,7
Avatar del usuario
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 en 0 día
5,0 (9 comentarios)
3,3
3,3
Avatar del usuario
experience 10 years in .net and ms sql server database development
$220 USD en 10 días
5,0 (4 comentarios)
3,0
3,0
Avatar del usuario
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 en 2 días
5,0 (2 comentarios)
1,8
1,8
Avatar del usuario
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 en 7 días
5,0 (1 comentario)
2,0
2,0
Avatar del usuario
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 en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I think that with 3 days I can finish... if you have the analysis of the database I can do some quickly.
$220 USD en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
A proposal has not yet been provided
$200 USD en 10 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I have very well experience in developing ssis packages and sql server.
$111 USD en 2 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
A proposal has not yet been provided
$91 USD en 2 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de UNITED STATES
Oakfield, United States
5,0
16
Forma de pago verificada
Miembro desde jul 22, 2013

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.