ACT DB reconciliation

[ben_citg]

Hi all,

I am hoping someone can help me here.  We're have a client for which we're developing a C#.NET factory control system, and they the factory system Customer DB to reconcile with the SageACT Customer DB.

We're confident that we can pull customer data straight from the MSSQL database, but we'd like to be able to push new contacts too.  Could we do this at a DB lever, or would this break everything?

I was wondering what the suggested method for implementing this feature would be, from those who know better than I.

Thanks in advance, Ben.

[mwood]

Hello Ben and welcome to the community.

Writing to SQL isn't possible without purchasing the SA password from us, you do however have read access directly, or through an ODBC or OLEDB connection. However, we do have a public facing API that will allow you to writie directly to a Sage Act database. It's free and you can download it from here. 

Some samples are included in the download and there's a lot of information already here, but if you have any questions don't hesitate to ask.

[ben_citg]

Hi Matthew,

Thanks for the quick response, I'll have a look.

Rgds, Ben