Automations
All questions related to Workflow Automation, AutomationEngine, and EdgeConnect, as well as integrations with various tools.
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Can I use Workflow +Edge to connect to databases via JDBC and run + capture SQL

GregOReilly
Advisor

Can I use Workflow +Edge to connect to databases via JDBC and run + capture SQL. Or is it only possible to run HTTPS connections?

4 REPLIES 4

Julius_Loman
DynaMight Legend
DynaMight Legend

You can do just http/https calls. There is no direct support of jdbc or any database engine in AppEngine. However, you can deploy rest2jdbc solutions and call them using EdgeConnect.

Dynatrace Ambassador | Alanata a.s., Slovakia, Dynatrace Master Partner

Thank you. Is rest2jdbc an extension?

Where can I find Dynatrace docs on how to deploy this? 

No, not an extension. I meant some generic rest to SQL solutions such as postgrest , oracle ords or data api builder. There are dozens of such projects, choose what fits your architecture and supports your databases.

Dynatrace Ambassador | Alanata a.s., Slovakia, Dynatrace Master Partner

GregOReilly
Advisor

As an update, my team have now created a "Postgres Custom SQL" Extension that allows us to connect and run custom SQL (Select top 10 from orders). This allows 10x database connections and unlimited queries that is pushed in JSON format directly back into bizevents. Works perfectly! 

Featured Posts