mock databse

[Anonymous]

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]

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:

1. create context environments - dev, test, prod and define different connections there
2. same as 1 but load data context variables (with connection details) from separate csv files
3. 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]

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]

connections - nothing more easy

schema - must be defined

[Anonymous]

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 ?