Need more, need help now?
- - - - - - - - - - - - - - - - - - pay-as-you-go support - no contract - tenth of an hour billing - expert help - fast service - no call queues
Need integration?
- - - - - - - - - - - - - - - - - - with your shipping system - website - invoicing system - crm - cms - manufacturing - order import - back to back orders..
Need a report?
- - - - - - - - - - - - - - - - - - Excel reporting that pulls data from Sage - custom layouts - layouts that change adapt to your brands and/or for drop shipping.
Want web hosting?
- - - - - - - - - - - - - - - - - - Your own domain name - email - a shop - wordpress - woo commerce - ticket systems - help desks - forums - portals

Sage 50 UK ODBC driver for data imports by .net desktop application

Sage 50 general help forum - Free help and support for all general issues
Post Reply
RinuM
User
User
Posts: 2
Joined: 05 Jun 2024, 18:34
Sage Version: v30 UK/Europe/Africa

Sage 50 UK ODBC driver for data imports by .net desktop application

Post by RinuM » 05 Jun 2024, 18:55

Hi,

Could we use Sage 50 UK ODBC driver as a reliable source for data fetching by a .net desktop application?

I have a desktop .net application that connects to Sage ODBC Driver for fetching few lists instead of using the SDK. Data is polled once everyday or on manual request. And for posting transactions, SDK is used.

Is it advisable to use ODBC than the SDK for data fetching?

When asked Sage support team, they said ODBC is not supported by them and it does have limitations like - "The ODBC driver exists as a by-product of the Sage 50 Accounts Report design engine and is used primarily to compile reporting information. It is not known to be fully ODBC II compliant and may also return deleted data."

User avatar
brucedenney
Site Admin
Site Admin
Posts: 4644
Joined: 28 Feb 2006, 09:56
Sage Version: v30 UK/Europe/Africa

Re: Sage 50 UK ODBC driver for data imports by .net desktop application

Post by brucedenney » 06 Jun 2024, 10:02

Your mileage may vary.

It depends on what you are doing, how big the database is and so on.

You should try it an see.

ODBC is slow.
For just about anything Sage :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.

RinuM
User
User
Posts: 2
Joined: 05 Jun 2024, 18:34
Sage Version: v30 UK/Europe/Africa

Re: Sage 50 UK ODBC driver for data imports by .net desktop application

Post by RinuM » 06 Jun 2024, 17:28

Thanks for the response!

Our customers could potentially have heavy data. To overcome pulling full data everyday, my app would be fetching the data modified from a certain Date.

And its for the same reason that I was debating whether to switch from SDK to ODBC as SDK doesn't have querying by Date filter with pagination.

1. Do you have any suggestions for implementing querying data with Date filter with pagination using SDK?
2. Do you know if SageODBC driver is odbc compliant? Sagesoft support team said it isn't. What I have seen so far is it doesnt support few querying options(LIMIT, OFFSET etc) but still can be manageable?
3. Does Sage support ODBC, couldn't find any support team details


Thanks!

User avatar
brucedenney
Site Admin
Site Admin
Posts: 4644
Joined: 28 Feb 2006, 09:56
Sage Version: v30 UK/Europe/Africa

Re: Sage 50 UK ODBC driver for data imports by .net desktop application

Post by brucedenney » 07 Jun 2024, 09:43

I don't use the SDK it is expensive, I use a 3rd party tool to write my integrations for others.

The ODBC drivers are slow, they use a comma as a separator or something like that, which makes some SQL ambiguous.

It is what the report designer uses and is functional for many if not most purposes.

You need to do a test to see if either is quicker than the other in your scenario.
For just about anything Sage :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.

Post Reply

Who is online

Users browsing this forum: Bing [Bot] and 2 guests