Find Jobs
Hire Freelancers

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

$30-250 USD

Κλειστή
Αναρτήθηκε περίπου 7 χρόνια πριν

$30-250 USD

Πληρωμή κατά την παράδοση
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.
Ταυτότητα εργασίας: 14336781

Σχετικά με την εργασία

16 προτάσεις
Απομακρυσμένη Εργασία
Ενεργός/ή 7 χρόνια πριν

Ψάχνεις τρόπο για να κερδίσεις μερικά χρήματα;

Πλεονεκτήματα πλειοδοσίας στο Freelancer

Καθόρισε τον προϋπολογισμό σου και το χρονοδιάγραμμα
Πληρώσου για τη δουλειά σου
Περίγραψε την πρόταση σου
Η εγγραφή και η πλειοδοσία σε εργασίες είναι δωρεάν
16 freelancers δίνουν μια μέση προσφορά $197 USD για αυτή τη δουλειά
Avatar Χρήστη
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 σε 7 ημέρες
4,9 (55 αξιολογήσεις)
5,8
5,8
Avatar Χρήστη
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 σε 3 ημέρες
4,7 (19 αξιολογήσεις)
4,7
4,7
Avatar Χρήστη
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 σε 0 ημέρα
5,0 (9 αξιολογήσεις)
3,3
3,3
Avatar Χρήστη
experience 10 years in .net and ms sql server database development
$220 USD σε 10 ημέρες
5,0 (4 αξιολογήσεις)
3,0
3,0
Avatar Χρήστη
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 σε 2 ημέρες
5,0 (2 αξιολογήσεις)
1,8
1,8
Avatar Χρήστη
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 σε 7 ημέρες
5,0 (1 αξιολόγηση)
2,0
2,0
Avatar Χρήστη
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 σε 3 ημέρες
0,0 (0 αξιολογήσεις)
0,0
0,0
Avatar Χρήστη
I think that with 3 days I can finish... if you have the analysis of the database I can do some quickly.
$220 USD σε 3 ημέρες
0,0 (0 αξιολογήσεις)
0,0
0,0
Avatar Χρήστη
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 σε 3 ημέρες
0,0 (0 αξιολογήσεις)
0,0
0,0
Avatar Χρήστη
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 σε 1 ημέρα
0,0 (0 αξιολογήσεις)
0,0
0,0
Avatar Χρήστη
A proposal has not yet been provided
$200 USD σε 10 ημέρες
0,0 (0 αξιολογήσεις)
0,0
0,0
Avatar Χρήστη
I have very well experience in developing ssis packages and sql server.
$111 USD σε 2 ημέρες
0,0 (0 αξιολογήσεις)
0,0
0,0
Avatar Χρήστη
A proposal has not yet been provided
$91 USD σε 2 ημέρες
0,0 (0 αξιολογήσεις)
0,0
0,0

Σχετικά με τον πελάτη

Σημαία της UNITED STATES
Oakfield, United States
5,0
16
Επαληθευμένη μέθοδος πληρωμής
Μέλος από Ιουλ 22, 2013

Επαλήθευση Πελάτη

Ευχαριστούμε! Σου έχουμε στείλει ένα email με ένα σύνδεσμο για να διεκδικήσεις τη δωρεάν πίστωση σου.
Κάτι πήγε στραβά κατά την προσπάθεια αποστολής του email σου. Παρακαλούμε δοκίμασε ξανά.
Εγγεγραμμένοι Χρήστες Συνολικές Αναρτημένες Δουλειές
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Φόρτωση προεπισκόπησης
Δόθηκε πρόσβαση για Geolocation.
Η σύνδεση σου έχει λήξει και τώρα έχεις αποσυνδεθεί. Παρακαλούμε συνδέσου ξανά.