There is no way to edit the connection profile properties once the model is created. The easiest thing to do is delete the model and redo the import with correct information.
1 of 1 people found this helpful
Try, right mouse click on model and select MODELING --> SET CONNECTION PROFILE
Create a new connection profile and then select it to replace the existing one. Then when you view the connection info, it will be updated with the newly created/selected connection profile.
Thanks Ramesh and Van...
However, Van when I tried to set connection info to a different connection name, it kept chugging...
I forcibly killed it.
When setting a new connection, In the window for NEW DRIVER DEFINITION I have to enter the connection properties to the db... otherwise I am not able to save it. Wondering if the Driver definition is the right place for entering this information. So for each new db, I need to create a new driver definition - even though I am using the same ojdbc6.jar? Want to confirm if I am doing this the right way.
You only need to create once for new driver definition, after that you keep selecting the driver definition to create connections.
Yes, the Driver Definition basically provides the Connection URL Template, Driver Class name and driver JARs list.
A connection profile defined with that Template, will still need the URL properties defined as well as username/pwd/database name, etc....