Test Data Manager

 View Only
Expand all | Collapse all

MySQL multi schema data publish

  • 1.  MySQL multi schema data publish

    Posted Oct 15, 2018 07:09 AM



    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


    Table A1

    |- ID_A

    |- Val_A1

    |- Prop_A


    Table A2

    |- ID_A

    |- Val_A2

    |- Prop_A2



    DataBase B


    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 Oct 17, 2018 01:34 AM

    Any updates?