I set the db credentials in kettle.properties,
i set the variables with credentials in data source successfully
but when i click preview it gives me this error, it seems that it can't recognize the variable
This is how I declared the variables in kettle.properties
How can I solve?
Asked
Active
Viewed 101 times
0
Cristina Moretti
- 77
- 8
1 Answers
1
1.I just use mysql instance, your kettle.properties is right.
2.Have you try to ping url of your db and login in your centos or ubuntu?
3.I think the most important problem is network and authority of db in whitelist.
4.My kettle
Anthony Cesar
- 31
- 3
-
do you mean try turning off the firewall of the oracle db? – Cristina Moretti Nov 24 '22 at 16:00
-
Have you try to ping ip of Oracle? – Anthony Cesar Nov 24 '22 at 16:29
-
And close you firewall of you PC, just for a second – Anthony Cesar Nov 24 '22 at 16:30
-
If it dosen't work, I will find another way, don't worry, i think is't not hard – Anthony Cesar Nov 24 '22 at 16:31
-
Thanks, I tried what you said but it doesn't work. If I set the data in clear text, without using the variables, I can run the preview. But I must use variables – Cristina Moretti Nov 24 '22 at 16:36
-
Ok, I will find another way tomorrow. Could you post some picture with variables? – Anthony Cesar Nov 24 '22 at 18:14
-
Ok thank you, I edited the post by inserting the declaration of the variables in the kettle.properties – Cristina Moretti Nov 25 '22 at 08:31
-
I will try tonight, give me some time. – Anthony Cesar Nov 25 '22 at 09:49
-
Yes I'll wait, thank you – Cristina Moretti Nov 29 '22 at 11:06
-
Sorry, I'm late. There are lots of works to do. – Anthony Cesar Nov 29 '22 at 13:19
-
Hi, I see you use Spoon, is it the same as report designer? – Cristina Moretti Nov 29 '22 at 13:43
-
Right, it's same. Why don't try use mysql, because it's a little diffcult. In order to find you problem. – Anthony Cesar Nov 29 '22 at 18:03
-
I show you in the answer. Just leave some word if you have any question, we can discuss. – Anthony Cesar Nov 29 '22 at 18:05