Community
Showing results for 
Search instead for 
Do you mean 
Reply

Sync ACT Database with MySQL

Copper Contributor
Posts: 41
Country: United States

Sync ACT Database with MySQL

Is anyone aware of a solution (3rd party or other) which would allow me to sync our ACT! Database with MySQL?

 

Chris

Platinum Elite Contributor
Posts: 14,384
Country: Australia

Re: Sync ACT Database with MySQL

The best options can depend on how you want it to sync... do you want it to go in both directions or just one way?
Real time or batch?
Copper Contributor
Posts: 41
Country: United States

Re: Sync ACT Database with MySQL

Thanks Mike - both ways would be great, however ACT to MySQL is the priority.

 

Chris

Platinum Elite Contributor
Posts: 14,384
Country: Australia

Re: Sync ACT Database with MySQL

That wouldn't be too hard... you can read the ACT! database via OLEDB or ODBC (if using Premium).

 

See: http://blog.glcomputing.com.au/2009/07/connecting-to-act-by-sage-data.html

 

It wouldn't probably need to be something custom as it would need to know your MySQL structure.

 

We do custom solutions like this pretty often.

Copper Contributor
Posts: 41
Country: United States

Re: Sync ACT Database with MySQL

Thanks Mike, can we set aside some time to discuss over the phone?

 

Chris

Platinum Elite Contributor
Posts: 14,384
Country: Australia

Re: Sync ACT Database with MySQL

Platinum Elite Contributor
Posts: 6,537
Country: USA

Re: Sync ACT Database with MySQL