prasanna.kulkarni wrote:Hi,
Thanks for the screenshots, they're helping.
There are two different issues:
1. The screenshot and pop-up shown in error.png, is not actually an error. It's a guiding message to administrator that administrator should install the JDBC provider snap-in on desired cluster. (Detailed helping message is there in error.png)
What this means is as below -
a. Once you create a JDBC Provider, click OK on this pop-up.
b. Go to "Service Management" page and a snap-in with "Deployment Type = JDBC Provider" would be created, the snap-in name would be same as JDBC Provider you created in step 1a.
c. You should install this snap-in on any cluster where this JDBC provider is needed. (Installation is similar to any other regular snap-in.)
d. Then you can go to "Configuration->JDBC Sources" configuration page and create data sources by providing external DB details.
2. The service_database.png shows a screen which lists all the services, which are using Breeze's built-in cluster DB. This screen does not show any information regarding JDBC Providers or JDBC Data Sources that we create to connect to external DB.
To create/check JDBC data sources please visit, "Configuration->JDBC Sources" page.
If you face any problems when/after performing above mentioned steps, please let me know.
Thanks,
Prasanna
Thank you for the explanation.
I was able to install the SQL JDBC under Service Management/Services then Create a JDBC Data source to use in the work flow.