Build a Connector to the Sage CRE 2017 SQL Server system

We are looking for a talented C# developer with advanced SQL Server knowledge to build a connector to the Sage CRE 2017 SQL Server system and download data for nine (9) metrics that will be used to feed into a Power BI report.

The work is expected to take one week to complete, upon approval, and a bonus amount of 10% will be awarded for delivering one day earlier or better.

The successful candidate should be able to demonstrate recent experience extracting data from Sage CRE 2017 and proficiency with C# and SQL Server.


The developer must possess the following qualifications:

 Demonstrated experience with SQL Server RDBMS

 Advanced T-SQL knowledge and ability to structure queries

 Experience with C#, .net Core, and Entity Framework Core 2.2

 Experience extracting data from Sage CRE 2017 SQL Server and advanced working knowledge of its schema


The performance review is provided on a 5-star basis with the stars assigned as follows:

3 stars for delivering the working project on or before the deadline

1 star for the quality of the source code and following the delivery criteria and other specifications

1 star for proper consideration of unit tests and full code coverage including forced error testing

Note: The timeline is of exceptional importance to us and our clients. We may never, under any circumstances, request more time for a small project such as this unless the scope of the project changes.


This work must be completed by the 21st of June, 2019.


The budget for this work is $50 CAD per hour, up to a maximum of $2,000 CAD. The project is not to exceed the maximum budget, and the developer guarantees with confidence that this can be accomplished.


The client requires a Sage CRE 2017 data connector written in C# which is capable, upon being executed, of pulling data from the Sage system, transforming it into the needed output formats, and saving it in SQL Server.

 Design SQL schema needed to store data for Power BI reporting

 Connect to Sage SQL Server

 Write queries to pull data into a row-based ledger with time stamps to track synchronization status

 Write queries to pull data from ledger data store into a star schema for reporting purposes


 Proposed design (ERD) of Sage data store (star schema)

 Proposed design (ERD) of Sage synchronization ledger table

 Product source code

 C# .net Core 2.2 library project “[login to view URL]”

 C# X-Unit test project “[login to view URL]”

 C# SQL Server project “[login to view URL]”

 Minimum two unit tests for each public method in the connector library, one for successful pass and one for each potential failure condition


 Developer will be provided with connectivity to git

 Client will be available to answer questions as needed throughout the project with a minimum response time of same-day response

 Project will be built using (or compatible with) Visual Studio 2019

 The developer is not required to build dimension tables for time unit, this will be done at the Power BI reporting layer


 The code must operate in a stateless manner

 Concurrent processes of the same code can operate independently of each other

 Process is capable of being interrupted and resume work where it left off

 Process does not require downloading data that has already been downloaded


The developer is expected to provide answers to the following question upon project completion

 What is the optimal way to configure the star schema for Power BI query performance?

 What is the fastest way to reliably extract data from Sage 2017 CRE?

 How can we design the synchronization ledger to allow for

 Multiple concurrent processes in parallel without overwriting any data

 Fault tolerance by resuming the synchronization if interrupted

 Fault tolerance by avoiding any half-written records if interrupted

Kemahiran: Pengaturcaraan C#, Pembangunan Pangkalan Data, Pengaturcaraan Pangkalan Data, Pelayan Microsoft SQL, SQL, Sistem Admin, Systems Engineering

Lihat lagi: validate records sql server, build sql server database driven photo gallery website, sql server records within radius, build bcp import script sql server 2000, append records access table sql server linked, build script sql server 2000, insert records sql server 2005, php delete sql server records, vbnet inserting records sql server database, build iphone app retrieve data sql server, update records sql server table using vba odbc, access 2007 sql server records, use ado insert records sql server, add records excel sql server table, build rule engine database sql server, add records sql server express access vba, build sql server rule engine, sql server 2017 rc, sql server send email based on query results

Tentang Majikan:
( 3 ulasan ) Toronto, Canada

ID Projek: #19970187

31 pekerja bebas membida secara purata $2283 untuk pekerjaan ini


Hi there! I've read the details you mentioned and I'm interested in working on this project! If you give us your few minutes for the chat then we can discuss some important points about project to go ahead further wit Lagi

$3000 CAD dalam 45 hari
(110 Ulasan)

Hello dear, I have read your requirements for building Building a Connector to the Sage CRE 2017 SQL Server system. I have 10 years of experience as a C#.Net Developer, I have mostly worked on web-based applicat Lagi

$2000 CAD dalam 30 hari
(11 Ulasan)

Hello, We are IT-Engineers and Business Analysts, creating complete web and mobile solutions, for already more than 15 years, supporting our products with custom digital marketing strategies and instruments. Befo Lagi

$3000 CAD dalam 30 hari
(14 Ulasan)

Hi, I hope you're having a wonderful day My video portfolio: [login to view URL] I am rated in top 3% freelancers here on my .Net C# Programming skills. I make sure you get quality p Lagi

$2100 CAD dalam 7 hari
(29 Ulasan)

Nice to meet you. I'm sure I can satisfy you ! I've rich experience with PHP(CodeIgniter, Laravel, Yii), NodeJS, HTML, Javascript, JQuery, AngularJS, ReactJS, CSS, JSP, .Net, MySQL, Python(Django, Flask) and so on. I'm Lagi

$2250 CAD dalam 20 hari
(13 Ulasan)

Hi there, I have checked the details I have great experience with C# Programming, Database Development, Database Programming, Microsoft SQL Server, SQL, System Admin, Systems Engineering. Please start the chat so we ca Lagi

$2500 CAD dalam 30 hari
(19 Ulasan)

hello,how are you. i read your bid carefully. i am C#, .Net expert and have full experience for 13 years. C#, .Net is my top skill and my interested skill. I can provide most quality and high fast. if you want to s Lagi

$2500 CAD dalam 30 hari
(6 Ulasan)

Hello, I have seen your project detail and fell comfortable I will implement this as per your need. I am C#, .Net expert and have full experience for 7 years. C#, .Net is my top skill and my interested skill. I can p Lagi

$2500 CAD dalam 30 hari
(7 Ulasan)

Dear As I am a senior software developer, have rich experience with various application development using C#, VC, VB.Net, NodeJS, Matlab, java, and python If you are interested with my proposal, please let me know i Lagi

$1500 CAD dalam 15 hari
(4 Ulasan)

Hello, I'm a talented Windows C#/MVC/Unity C# programmer with 10+ years of exp. I agree to your payment plan absolutely. And I suggest your provide som data files which I have to use to start this project. I am going t Lagi

$2000 CAD dalam 7 hari
(7 Ulasan)

hello,how are you. i read your bid carefully. i am C#, .Net, SQL Server expert and have full experience for 7 years. C#, .Net, SQL Server is my top skill and my interested skill. I can provide most quality and high Lagi

$2500 CAD dalam 30 hari
(7 Ulasan)

Dear Sir. Glad to meet you. I'm very interested in your job post involving these skills. I'll bring your idea to the next level or extend your live project with new awesome features. I'm web Developer specializing in Lagi

$2250 CAD dalam 7 hari
(2 Ulasan)

Hi, I can work on the project with immediate availability. My only concern is time.I think for new project no one can complete it until code is already written. Let's have quick discussion over the project so I can w Lagi

$2000 CAD dalam 15 hari
(27 Ulasan)

Dear sir. I have read your description with great interest. I have experiences with lots of project. Also I am able to finish your task in time. If you send me a message, we can discuss more. I am waiting for your Lagi

$2000 CAD dalam 10 hari
(4 Ulasan)
$3333 CAD dalam sehari
(2 Ulasan)

Hi, there. Very interested and I've read all of your description carefully. I'm an expert in C++ and C# Application development. I assure that I can do your work with 100% satisfaction. I am looking forward to your Lagi

$2250 CAD dalam 7 hari
(5 Ulasan)

Hello, I saw all details properly and i have very confident i can Build a Connector to the Sage CRE 2017 SQL Server system. i am really very interested to get start. just knock me via chat. Thanks Rashedul

$2000 CAD dalam 7 hari
(2 Ulasan)

Hello! I am a programming expert. I am good at C# I have checked your project description. If you hire me, I am gonna do my best for our project. I guarantee the good result. I will wait for your reply. Thank y Lagi

$2500 CAD dalam 30 hari
(1 Ulasan)

Hi, I have already build Sage connector and can demo it to you. Though its a basic connector. However, I can meet all your requirement. I have done similar work for Quickbooks as well. Please give me a chance to demo Lagi

$2250 CAD dalam 15 hari
(5 Ulasan)

Hello! I am very interested in your post project. I read through the job details extremely carefully and I am absolutely sure that I can do the project very well. I have worked on similar projects to what you are l Lagi

$2500 CAD dalam 30 hari
(1 Ulasan)