Indexing multiple tables from MySQL/MSSQL in one config-file

Hi everyone,

my task is to put our (in this case MySQL) tables into elastics search.
I made a config for one table and it worked really well. The problem is, that I have not one or two tables, but over 100.

So my idea is to index all and schedule them with only one config file using the statement_filepath to go over all statements for each table.

To get the output right, I thought I can use the metadata from each table to generate the index, document_type and document_id. For Example:

index => " TABLENAME + 's' "
document_type => " TABLENAME "
document_id => "TABLE PRIMARY KEY"

Is this even possible or is there even a better solution to put all of my data in ES?

Thanks for your help!