Which workato connector is most capable for Database

deepaks — Thu, 19 Sep 2024 17:59:18 GMT

Luckily I have autonomy to choose a database (AWS RDS based) - which connector has most wide connection+action capabilities (particularly for bulk ops)

I am inclined towards Aurora (so choice between MySQL or Postgres)

Re: Which workato connector is most capable for Database

gibson-cabello — Thu, 17 Oct 2024 01:25:12 GMT

Hi @deepaks,

For connecting to an Aurora database, you can use the following connectors supported by Workato:

PostgreSQL: If your Aurora database uses the PostgreSQL engine, you can use the PostgreSQL connector.
MySQL: If your Aurora database uses the MySQL engine, you can use the MySQL connector.
JDBC: For more advanced or custom configurations, you can use the JDBC connector.

These connectors support various actions, such as running queries, inserting, updating, and deleting rows.

Thank you!

Gibson Cabello

topic Which workato connector is most capable for Database in Workato Pros Discussion Board

Which workato connector is most capable for Database

Re: Which workato connector is most capable for Database