question about custom module

[lausing]

Hi all,

could u tell me how to connect to a different database(other than sugar db) in a new custom module? Do u think I can still use the sugar template to show the data from another db?
OR actually how can I made my own query in sugar?Thanks. I'm really appreciated ur helps.

Regards,
Richard

[eggsurplus]

Short answer: yes.

There are tons of ways to do this. Easiest way is to create the custom module in Studio/MB and deploy. Then override the custom module bean's retrieve function to call your external database. I'd suggest a 3rd party db library like adodb. I've hacked Sugar's db lib to use the same lib in the past but it's not worth it. I've since switched to adodb which works quite well. You'll also need to override create_new_list_query for the list views. There should be some examples on this forum. Searching Google works best (site:sugarcrm.com/forums retrieve external database).

[lausing]

thx for your reply eggsurplus. sorry for the confusion. Actually, I have them in the same host but just diff databases like db1 and db2. Like, in sugarconfig it sets up the db config to db1(sugardb) ... so how can I get some of the data from db2 and related to sugardb? Thanks.

[jayrb]

MySQL will let you access a different database other than the one selected. Just prefix your table name with the database name in your query.

SELECT * FROM db2.mytable

The key is that both databases must be using the same user/password. If the user/pass is different, you will need to create a new db connection using the appropriate credentials. I find this isn't an issue because it just makes sense to use the same db user if you have two apps sharing data like this.

Hope this helps!

Jay