Test Data Manager

Expand all | Collapse all

MySQL multi schema data publish

  • 1.  MySQL multi schema data publish

    Posted 10-15-2018 07:09 AM

    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?



  • 2.  Re: MySQL multi schema data publish

    Posted 10-17-2018 01:34 AM

    Any updates?