Community
Showing results for 
Search instead for 
Do you mean 
Reply

ACT DB reconciliation

New Member
Posts: 2
Country:

ACT DB reconciliation

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.

Employee
Posts: 1,163
Country: USA

Re: ACT DB reconciliation

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.

Matthew Wood
Act! SDK Support
Community Moderator
New Member
Posts: 2
Country:

Re: ACT DB reconciliation

Hi Matthew,

 

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

 

Rgds, Ben