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

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 Francesca!

Thank you for your response!

Effectively, I would like to know if exists some limitations to stablish this connections, I need to connect to a SQL database. If my integration was in OnPremise mode, wouldn't problem, but my instance is OnPremise type.

So, I will try write the code that php offers to make SQL connections, specting that the module loader allows it.

Regards!

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.