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
Now accepting applications for the Qlik Luminary and Partner Ambassador Programs: Apply by July 6!
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
720 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.

536 Views
0 Likes