Datafetch from other DB

[john.dsouza]

Dearl All,

Can you please let me know is this possible in sugar . .

what I have done?
I have created one student list module from backend and deplyoed it under student tab.

(Problem statement )what I have to done?
I have 2 site one Joomla and Another is Forum, what I want to do is map both joomla and forum users through CRM the idea is if have made some changes in these users it will be refelected in assigned sites

I can see my module in crm/module/student here I want to let us know how can I connect to another db.

[kuske]

It is very simple.
Just make al little include module with some basic access routines to your external database. Include this in your students module and use it for data exchange to the external system.

Or use some ETL tool (Like Talend) to connect both databases.

[john.dsouza]

It is very simple.
Just make al little include module with some basic access routines to your external database. Include this in your students module and use it for data exchange to the external system.

Or use some ETL tool (Like Talend) to connect both databases.

Dear kuske,

I really appreciate your help, can you please elaborate a little bit not able to understand what you exact mean

Thanks John

[john.dsouza]

anyone faced the above issue?

[kuske]

3 years ago anyone in this forum posted a very useful file /include/classes/mysql.php which I atach to this post.
With this file you can open any other mySQL (I hope you have a mySQL Joomla!) database and work on its data.

The usage is very simple like that:

include("include/classes/mysql.php");
$db = new sql_db($hostname,$dbuser,$dbpassword,$dbname);
$db->sql_query($sql);
$db->sql_fetchrow($db->query_result)) ...