Which workato connector is most capable for Database

[deepaks]

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)

[gibson-cabello · Accepted solution]

Hi @deepaks,

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

1. PostgreSQL: If your Aurora database uses the PostgreSQL engine, you can use the PostgreSQL connector.
2. MySQL: If your Aurora database uses the MySQL engine, you can use the MySQL connector.
3. 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