Looking for plugin/module to view external databases

[jsherk]

Does anybody know if there is a plugin/module available that would allow you to view a database outside of the sugarcrm database (Using CE 5.2)?

I would like to be able to view data in another database on the same server (maybe on external servers in the future). Possibly would also like to import viewed data into SugarCRM database as well.

Any suggestions?

Thanks

[andopes]

Which database is that? Oracle, MS SQL, MySQL:
What is the Operating System where Sugar is installed?

Regards

[jsherk]

DB is MySQL
OS is Linux (one on Ubuntu and one of Centos)

[andopes]

You can use such function to create an instance database through SugarCRM tiself:

 function get_db($config) {
    if($config['db_type'] == "mysql") {
        $my_db_manager = (function_exists('mysqli_connect')) ? 'MysqliManager' : 'MysqlManager';
    } else if($config['db_type'] == "oci8") {
        $my_db_manager = 'OracleManager';
    } elseif($config['db_type'] == "mssql") {
        $my_db_manager = (is_freetds()) ? 'FreeTDSManager' : 'MssqlManager';
    }
 
    require_once("include/database/{$my_db_manager}.php");
 
    $db = new $my_db_manager();
    $db->getHelper();
    $db->connect($config, true);
 
    return $db;
} 
  

The $config array should looks like that:

         $config = array(
            'db_type' => $website_database_defs['dbtype'],
            'db_host_name' => $website_database_defs['hostname'],
            'db_user_name' => $website_database_defs['username'],
            'db_password' => $website_database_defs['password'],
            'db_name' => $website_database_defs['database'],
        ); 
  

After creating an instance you can invoke all regular methods on default $db variable.

Regards