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

Hello Everyone!

I have a question, exist some form to stablish a connection with an external DataBase from a LogicHooc or Scheduler?

I need get data from an external DataBase to insert in a module and I need make this in a Scheduler.

Regards!

Parents
  • 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! Smiley

Reply Children
No Data