Hi,
We want to publish data using Datamaker to MySQL databases. Currently, we are able to create a MySQL connection profile, connect to the db & publish data to the tables of a single schema.
Using Datamaker, Is it possible to publish data to tables existing in different MySQL schemas/databases from the same project. For instance, if there exists 2 schemas/dbs with sample tables like this:
DataBase A
contains:
Table A1
|- ID_A
|- Val_A1
|- Prop_A
Table A2
|- ID_A
|- Val_A2
|- Prop_A2
&
DataBase B
contains:
Table B1
|- ID_B
|- ID_A
|- Val_B1
|- Prop_B1
Table B2
|- ID_B
|- ID_A
|- Val_B2
|- Prop_B2
We want to create a project in datamaker that will allow us to publish data to Tables A.A1, A.A2, B.B1 & B.B2 with references to foreign keys across schemas|DBs as shown above.
Follow up questions:
1) On Datamaker publish, is there any way to obtain logs / output of the content that was published? Currently the logs generated on success do not contain any data on what content was added on publish.
2) Can the publish process be executed through an executable | JAR?