MS SQL Database can be accessed using user domain id through Oracle Weblogic Server data source. This can be achieved using open source MS SQL driver JTDS. It can be downloaded from https://sourceforge.net/projects/jtds/files/jtds.
PRE-CONFIGURATION STEPS:-
PRE-CONFIGURATION STEPS:-
- Download the open source JDBC driver for Microsoft SQL Server.
- Unzip the jtds-1.3.1-dist.zip
- Copy jtds-1.3.1.jar to $DOMAIN_HOME/lib
- Restart the servers
- Click on "Lock & Edit" under "Change Center"
- On the Home Page, Click on "Data Source" under "Services"
- Under "Configuration" tab, Click on "New", select "Generic Data Source". Give the Name & JNDI Name.For Database Type. Select "MS SQL Server".Click "Next"
- Select "Other" for "Database Driver"
Click "Next"
- Select the "Transaction Options"
Click "Next" - Provide "Database User Name" & "Password"
Click "Next"
- Driver Class Name: net.sourceforge.jtds.jdbc.Driver
URL: jdbc:jtds:sqlserver://mysqldb.mycompany.com:1433/DB_NAME;domain=MYCOMPANY;USENTLMV2=TRUE
Click on "Test Configuration"
Click "Next"
- Select Targets
Click "Finish"
Nice and good article. It is very useful for me to learn and understand easily. Thanks for sharing
ReplyDeleteSOA Training
Oracle SOA Training in Hyderabad