Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi I am pretty new to Talend. I have a requirement to create database on the fly using Talend tool before proceeding with other talend jobs. How do I achieve this?
Hello,
We support for setting up database connection and creating new table for a specific type of database by using talend components.
With your job requirement, could you please give us more description and background about your database on the fly?
Best regards
Sabrina
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.
Any update on above?
Hello,
There is no a specific component for creating database in talend. We have redirected your issue to our product experts and then come back to you as soon as we can.
Best regards
Sabrina
Thanks @Xiaodi Shi