Hi,
Is there any way to run a procedure from the etl. I have a quite complecated procedure I want to run on SQLserver and then transfer the output to a table in MYsql.
oren
Is there any way to run a procedure from the etl. I have a quite complecated procedure I want to run on SQLserver and then transfer the output to a table in MYsql.
oren
4 Answers:
Posted on March 13, 2008 at 4:02pm
Hi Oren,
Yes, the tool tMSSqlSP calls the database stored procedure. There are more details in the documentation.
Also, the section "Finding a State Label using a stored procedure" may be useful for you. It's not precisely the same as the job you want to do, but it should give you a good sample of using a stored procedure.
Regards,
Matt
JasperSoft
Yes, the tool tMSSqlSP calls the database stored procedure. There are more details in the documentation.
Also, the section "Finding a State Label using a stored procedure" may be useful for you. It's not precisely the same as the job you want to do, but it should give you a good sample of using a stored procedure.
Regards,
Matt
JasperSoft
Posted on March 20, 2008 at 12:01pm
thank you,
It looks like this component does'nt exist in the documentation or in the Jasper-etl. Are you sure you meant tMSSqlSP. Maybee it apears in a more advanced version of etl. I have a 2.1.2 version installed. How can see this component? Does it require an update?
best regard,
Oren
It looks like this component does'nt exist in the documentation or in the Jasper-etl. Are you sure you meant tMSSqlSP. Maybee it apears in a more advanced version of etl. I have a 2.1.2 version installed. How can see this component? Does it require an update?
best regard,
Oren
Posted on April 10, 2008 at 9:19pm
Oren,
Sorry, I forgot to come back to this thread to reply. JasperETL 2.3.2 is currently available for download. There had been some old links that made it harder to find, but it should be easy to find the download now.
Please let us know if you have trouble finding it.
Regards,
Matt
Sorry, I forgot to come back to this thread to reply. JasperETL 2.3.2 is currently available for download. There had been some old links that made it harder to find, but it should be easy to find the download now.
Please let us know if you have trouble finding it.
Regards,
Matt
