Setting up an ODBC with SugarCRM

[hsjunker]

I need to get into my SugarCRM database by setting up an ODBC connection. Can anyone help me with this?

[mcatling]

Hi,

It depends what database you are using....

If you are using a windows server and MySQL you need to go to the MySQL website and download their ODBC driver. Install it on your server and any clients that you want to use to access the database. The same is basically true if you arer on Linux but I dont use linux at the moment so am not familiar with the process.

Then in the XP adinistration panel there is an option for ODBC setup.

In this setup add a new ODBC connection and select the MySQL driver give it a name and fill in the other parameters (DB name and password etc). That should do it for you.

If you then go to any of the clients that support ODBC i.e. Access, Openoffice base, MS Query you should be able to setup an ODBC link and select the ODBC connection you have just created.

I use this with Openoffice base to do reporting (with the Sun report writer extension) and also for doing data maintenance. If you do use Openoffice base make sure you select a direct MySQL connection and then select ODBC. If you just select the ODBC link option you can not do some advanced things in Openoffice base such asas create a new view of the tables.

I have to do this and create new views on the database to link main Sugarcrm tables to the tables created if you do customisations and add new fields in Sugarcrm studio. For example in cases I have added 10 new fields. These are not stored in the Case table but in the Case custom table with a one to one link. It is easier for reporting to create a view linking the tables and just use the view for reporting.

I hope this helps

[JVWay]

To follow up on what mcatling was saying here's a link that explains some of the OpenOffice Base stuff.

http://rpbouman.blogspot.com/2006/12...officeorg.html


On Linux, at least in Ubuntu it's dang simple 'sudo aptitude install libmyodbc, then create a odbc.ini file in /etc like this:

[ODBC Data sources]
sugar = MyODBC 3.51 Driver DSN

[sugar]
Driver = /usr/lib/odbc/libmyodbc.so
Description = MyODBC 3.51 Driver DSN
Server = <server nane>
PORT = 3306
USER = root
Password = xxxxx
Database = sugarcrm
OPTION = 3
SOCKET =

[Default]
Driver = /usr/local/lib/libmyodbc3.so
Description = MyODBC 3.51 Driver DSN
SERVER = localhost
PORT =