Can I connect to an external DataBase to get data in a LogicHook or Scheduler?

I don't know if there are limitation for cloud customers but we're on site and we have a number of connections to our other databases that pull in data into logic hooks, dashlets, quoted line items and more. You can use the tools that PHP has for you to establish such connections. 

How exactly you go about connecting will depend on the database you are working with. We've done it with MySQL, Oracle, Postgres....
Some are direct DB connections to perform straight database queries, others are API calls.

FrancescaS

Hi again FrancescaS

I'm researching this case, but I'm thinking that maybe it couldn't be possible, because to make a SQL connection it's necessary to use the "mssql_connect" method and to be able to use this it's necessary to have the "php_mssql.dll" extension installed on the server. ; so I'm assuming SugarCRM doesn't have this installed, haha.
still i will try.

Thank you again for your response.

Norberto Baltézar.

Ah yes! I had my sysadmins install all sorts of PHP extensions to our servers OnSite.

Sorry!

Francesca

Ah yes! I had my sysadmins install all sorts of PHP extensions to our servers OnSite.

Sorry!

Francesca