Salesforce External Data Retrieval via .Net Web Service
This is a system I designed which allows Salesforce to receive data from an external system. The high level requirements were to push data from a SQL Server cluster in my client's data center into Salesforce while validating the data in transit. I had to account for data batching, connection loss, and other issues. This system utilized .Net, C#, Entity Framework, LINQ, APEX, JAVA, SQL CLR, SQL Stored Procedures, SQL Agent Jobs, and SQL Triggers. I designed the .Net Web Service using asynchronous batching which spun up multiple threads in the Salesforce cloud allowing massive amounts of data throughput. You will see a screen shot showing the first million records pushed into Salesforce during prototyping.\ \ The Architecture Diagram provided has been changed from its original version to protect my client's specific design, infrastructure details, and other sensitive information. \ \ The 1 million record test screen shot has also been cleaned of all sensitive information.
About Me
I am an experienced Developer, Designer, and Technical Leader. I have provided technical solutions to companies in the Financial, Insurance, Government, Manufacturing, and Real-estate industries for over 15 years. I have experience in .Net Framework, .Net Core, C#, Salesforce, Java, APEX, SQL, Oracle, Angular JS, SQL Lite, Java Script, Node JS, Azure, AWS, and more. If you can dream it, I can design and build it.
$ 100 USD/hr
NEW FREELANCER!
