Sugar CRM to replace Access DB and VB interface?

**zoharc** · 2012-01-25, 03:38 PM

My apologies if this question has been asked before. I've ben searching online for the past week, and couldn't find a satisfactory answer.

I have a device which runs on a local computer. It feeds the computer specific sensory data to a VB interface, which querys and retains the information on MS Access, and loads specific formulas which prints out an appropriate report. So far no problem, everything works great.

However, I have been looking for a way to duplicate the device, and switch from a local access db to a SQL db. Hopefully, in the future, it will have thousands of incoming feeds.

I was wondering if:
1. is it possible to import the existing databases and queries, simply to replace the vb interface with sugarcrm as a SQL connector?

2. How will I go about on importing all existing table data to sugarcrm? I have ran several localized tests on sugarcrm, just to get a taste of it. but even though it imported it to SQL easy, but I am not sure how to specify the tables, or structure the table so sugarcrm will be able to access them.

3. is it possible to feed sugarcrm with vb basic code using certain modules?

Please forgive any newb questions. I just want to know if this is the right direction. Would I be better off rewriting the vb apps to communicate directly to the sql on local computers using sugarcrm, or anything else as a connector.

**kbrill** · 2012-01-27, 04:13 AM

Originally Posted by zoharc

Please forgive any newb questions. I just want to know if this is the right direction. Would I be better off rewriting the vb apps to communicate directly to the sql on local computers using sugarcrm, or anything else as a connector.

It's hard to tell from what you said but if you are only using SugarCRM as a connector to SQL then you would be better off writing a purpose build VB app.

If your data has anything to do with relationship between DB tables then maybe SugarCRM sould be a good thing for you but I dont know what you mean by "computer specific sensory data" and it doesnt sound very CRM related to me.