Smart SQL Setup for Oracle - Datacap 8.1

• Install Oracle client tools
• Create folder if does not exists C:\app\<<UserId>>\product\11.2.0\client_1\network\admin
• Copy  tnsnames.ora file to above folder with appropriate connection values.
• Create TNS_ADMIN environment system variable and point to  C:\app\<<UserId>>\product\11.2.0\client_1\network\admin\
• Create Oracle System DSN:
• Open C:\Windows\SysWOW64\odbcad32.exe in Administrator mode.
• Select “System DSN” tab.
• Click on “Add” button.
• Select “Oracle in OraClient11g_home1” driver

• Enter required input values.
• Click on “Test Connection” button. It would prompt for password.

• Create DataSource in "Taskmaster Application Manager"
• Click “Add New” in “Datasource Connection String Values in Taskmaster Format” section.
• Enter required values in Connection String editor popup window.

• Implement SmartSQL in Datacap model.