Hello everyone!
I created a VCI (Virtual Catolog Item) and created a Monitoring Project with Rules in Atacama One, using a Post Processing Plan I wanted to upload the result of the monitoring project to databases, in Atacama One we have a csv file with the results in the Export tab, but I can't upload it to the database, the database is empty. Сreated a Global Runtime Configuration, but there is no result. Who has faced such a problem?
Best answer by pdanpoonkij
Hello, I’m not sure if this has already been resolved, but there are a couple of ways you can write data to a database from within the post-processing plan. You should start by replacing your text file writer step with a JDBC writer step (similar to the screenshot below).
In the post-processing plans, you can use the connections defined in the Ataccama ONE web application. Please see the screenshots below, where we navigate to the Ataccama One Source connection page. Here, you can get the connection id from the URL (as highlighted). And then, you can use this id as a Data Source Name in the JDBC Writer step.
Don’t worry about the red X icon here as the plan will be execute from Ataccama One and it will recognize this id there.
Hopefully this helps you 😀
+3Hi
+3Hi again
Did you change you Post processing plan output to DB Object and updated the runtimeconfig file? if yes, then restart DPM
Hello, I’m not sure if this has already been resolved, but there are a couple of ways you can write data to a database from within the post-processing plan. You should start by replacing your text file writer step with a JDBC writer step (similar to the screenshot below).
In the post-processing plans, you can use the connections defined in the Ataccama ONE web application. Please see the screenshots below, where we navigate to the Ataccama One Source connection page. Here, you can get the connection id from the URL (as highlighted). And then, you can use this id as a Data Source Name in the JDBC Writer step.
Don’t worry about the red X icon here as the plan will be execute from Ataccama One and it will recognize this id there.
Hopefully this helps you 😀
A post processing component has a different deployment model to main pipeline code deployed via git. If you want to write just one main pipeline to read all monitoring projects’ results and write them to a database it can be done, albeit complicated, via a ONE Metadata Reader.
Hi
Hello
Hello
Thank you for the prompt response, this was really helpful!
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
