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."
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
- - - - - - - - - - - - - - - - - - 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
-
brucedenney
- 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
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.
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.
Re: Sage 50 UK ODBC driver for data imports by .net desktop application
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!
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!
-
brucedenney
- 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
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.
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.
Who is online
Users browsing this forum: Ahrefs [Bot], billswan and 1 guest