topic Re: mock databse in Talend Studio

mock databse

Anonymous — Tue, 05 Mar 2019 10:39:24 GMT

Hi. I'm using Talend Open Studio for Data Integration.

I would like to mock database in tDbInput for my job's test,

because i don't want to change the real database data.

Does anyone know how to do this?

Thanks, best regards.

vapukov — Tue, 05 Mar 2019 11:16:06 GMT

Hi,

Talend contain tRowGenerator, which could help you generate dataflow, but it did not replace source in tDbInput component

it good for test other components like tMap, filters and etc, but when you use tDBInput/tDBOutput you will work with real defined databases

you can:

create context environments - dev, test, prod and define different connections there
same as 1 but load data context variables (with connection details) from separate csv files
than create dev, test databases and use them in tests and development

in adition, if it required by security or regulation reasons - you could create procedures for mask data when prepare dev copy

if you need completely mock database - again you could use dedicate tools, I prefer dbSchema (www.dbschema.com)

Anonymous — Tue, 05 Mar 2019 12:48:36 GMT

Hi, Thanks for your reply.

How can I do this?

For query,I can make global context variable

(ex. query: select * from table1 CONTEXT_VAR1)

and put , from test code, the different value from its orignal.

But, I don't know how to set connection or schema as context.

vapukov — Tue, 05 Mar 2019 13:11:36 GMT

connections - nothing more easy

schema - must be defined

Anonymous — Tue, 05 Mar 2019 13:26:06 GMT

Hi, vapukov. Thank you. I've understood it.

I just want a 1 record select result different from real one.

It looks just a little much work for me that I make another data set.

is there any other solution ?