In Progress

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.

DEVELOPER QUALIFICATIONS

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

PERFORMANCE REVIEW

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.

TIMELINE

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

BUDGET

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.

SCOPE

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

DELIVERABLES

 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

ASSUMPTIONS

 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

ACCEPTANCE CRITERIA

 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

RESEARCH

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

Skills: C# Programming, Database Development, Database Programming, Microsoft SQL Server, SQL, System Admin, Systems Engineering

See more: 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

About the Employer:
( 3 reviews ) Toronto, Canada

Project ID: #19970187

31 freelancers are bidding on average $2283 for this job

jastp

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 More

$3000 CAD in 45 days
(111 Reviews)
8.1
rkatoch

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 More

$2000 CAD in 30 days
(11 Reviews)
6.6
devexpertsteam

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 More

$3000 CAD in 30 days
(14 Reviews)
6.6
adeelpirzada

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 More

$2100 CAD in 7 days
(29 Reviews)
6.3
AwaisChaudhry

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 More

$2500 CAD in 30 days
(21 Reviews)
6.8
C3guru

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 More

$2250 CAD in 20 days
(13 Reviews)
5.6
ITPyramid85

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 More

$2500 CAD in 30 days
(6 Reviews)
5.6
Ivan927

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 More

$2500 CAD in 30 days
(7 Reviews)
5.5
jk901

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 More

$1500 CAD in 15 days
(4 Reviews)
4.9
pathos821vw

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 More

$2000 CAD in 7 days
(7 Reviews)
5.0
Victorier006

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 More

$2500 CAD in 30 days
(7 Reviews)
4.8
sky930320

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 More

$2250 CAD in 7 days
(2 Reviews)
4.9
AliSafder

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 More

$2000 CAD in 15 days
(27 Reviews)
4.6
fivestar10

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 More

$2000 CAD in 10 days
(4 Reviews)
4.2
$3333 CAD in 1 day
(2 Reviews)
3.7
maximwang8661

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 More

$2250 CAD in 7 days
(5 Reviews)
3.6
sharmin283

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 in 7 days
(2 Reviews)
3.4
dreammate0621

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 More

$2500 CAD in 30 days
(1 Review)
2.8
akhileshgandhi

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 More

$2250 CAD in 15 days
(5 Reviews)
3.5
Molotova

⭐⭐⭐⭐ i am Full stack developer. ⭐⭐⭐⭐⭐⭐ I read through the job details extremely carefully and I am absolutely sure that I can do the project very well. * 6+ years experience in web and mobile app development. If More

$2000 CAD in 20 days
(1 Review)
1.7