-
1. Re: How to update data source connection
rareddy Jul 30, 2014 5:53 PM (in response to skanchi)Satish,
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.
Ramesh..
-
2. Re: How to update data source connection
van.halbert Jul 30, 2014 6:20 PM (in response to skanchi)1 of 1 people found this helpfulSatish,
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.
Van
-
3. Re: How to update data source connection
skanchi Jul 30, 2014 9:29 PM (in response to van.halbert)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.
Thanks.
- Satish
-
4. Re: How to update data source connection
rareddy Jul 31, 2014 9:26 AM (in response to skanchi)You only need to create once for new driver definition, after that you keep selecting the driver definition to create connections.
-
5. Re: How to update data source connection
blafond Aug 4, 2014 10:46 AM (in response to rareddy)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....