Sure, Similar to Create Table components, I am looking for component/way to create database. We have developed job per our requirement and exported as a batch file. This batch file will be used by multiple folks in the team for their validations. To be able to use this tool simultaneously, what I was thinking is to take current datetime (including milliseconds), pass it in a global variable using tJava and add that global variable in the create database query to be able to create unique db name every time tool is run and once completed, simply drop that database. That way multiple folks can use the tool same time without over stepping each other. Something like below:
tJava::
globalMap.put("current_date",TalendDate.formatDate("yyyyMMdd", TalendDate.getCurrentDate()));
Query: Create database globalmap.get("current_date")
And this current_date will also be passed in further tDBOutput component for database field.
