How do I set Camunda's database separately from spring.datasource.url?

I have spring data jpa on my application to connect to an Oracle database, if I introduce Camunda to this application how can I configure it so Camunda creates the tables on a MySql database?

Does this make sense? or is it a bad design? I read another thread where someone said I might encounter issues like rollback if for example an error happens on one of the database