Skip to Content

                           Configuration Steps in NWA to Connected 3rd Party Systems (MYSQL/Teradata. Etc.)


Configuration Management—->  Infrastructure—->  Click on “Application Resource.”

     1.PNG

Click on New JDBC Drivers

      2.PNG

Browse the “sqljdbc4.jar” file & deploy. If connected to Teradata will use Teradata related Jar files.


Create “New JDBC Custom DataSource Creation”


          3.PNG

Click on “New JDBC Custom Data Source Creation


Will provided these information “Driver Class Name”, “Database URL”, “username” and “password’ under “Setting” tab.

             4.PNG

Provide required information under “Connection Pooling” tab.

           10000.PNG

Provide required information under “Additional Properties” tab. If required.

              5.PNG

Add Resource name under “Antecedent JDBC Driver” tab.

               6.PNG

Add new alias name under “Dependent Data Source Aliases” tab

                7.PNG

Finally we will use this alias name into our WD-JAVA/EJB application.


                                             Kindly let me know if you need any more information


Regards

Vijay Kalluri


To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply