Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
krishnakv83
Contributor II
Contributor II

Changing the data source Oracle to Sql server

Hi Guys,

We need to change data source of existing dashboards.could anyone tel me what is the process to do that ?

Regards,
Krishna

3 Replies
Gysbert_Wassenaar

Create a new connection string to connect to the new database. And check if every sql statement still works. You may need to replace oracle specific functions with the SQL server equivalents. Your database administrators should be able to help you with this. Do that for every dashboard that will need to load data from the new SQL server databases.


talk is cheap, supply exceeds demand
ramasaisaksoft

Hi Krishna,

Same way u need to fallow ODBC/OLDB  connections as it is previously.

and check for temp dashboard confirm yourself sucess then u can proceed for PRD server apps

change the $file path variable Link

avinashelite

if using ODBC connection then you need add a fresh DSN in the server ....

1. Create a fresh connection in the Application.

2. Check all the table structure is same or not

3. Check the SQL syntax and check whether all the statement are working or not .