Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2012-07-26 10:38 AM

How to connect sales data from different sources

Hi,

I am designing sales statistics but we are in process of changing our ERP and I will need to connect to sales data from Oracle database up to a specificic date and from SQL Server from this date on.

How can I merge sales data from both databases into one list in QlikView? Any script example? Thanks!

Labels (1)
Labels
685 Views
0 Likes
1 Reply
Not applicable
‎2012-07-26 10:56 AM
Author

Hi,

You can create a qvw like historicload and connect to ORACLE to load a historicsales.qvd.

Add one more script to load SQL data and concatenate with historicsales. Point is that both the scripts should return same fields.

Kiran Rokkam.

501 Views
0 Likes