Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
rendiyan
Partner - Creator
Partner - Creator

[ASK] Connect to multiple DB3 Files

Dear Qlik Master,

i have a customer that required get data from db3 files.

FYI, 1 day of transaction = 1 db3 file.

All db3 files stored in 1 folder, with file format : [BRANCHID]_[SALESMANID]_[TRANSDATE].db3

I've never connect to db3 files before with qlikview.

Is there anyway to connect to multiple db3 files in 1 folder?

Thank You,

Best Regards,

5 Replies
sushil353
Master II
Master II

Hi,

Your ODBC connection is enough for loading the data from db..

and for loading data from all files present in the folder you can follow below thread..

loop through to load all files from a folder and its subfolders?

HTH

Sushil

rendiyan
Partner - Creator
Partner - Creator
Author

i don't have db3 odbc, where can i download it?

sushil353
Master II
Master II

jonathandienst
Partner - Champion III
Partner - Champion III

>>i don't have db3 odbc, where can i download it?

Speak to your DB3 administrator and/or vendor, or google for one (if there is a free version available).

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
rendiyan
Partner - Creator
Partner - Creator
Author

ok i've downloaded the odbc.

but the problem is, 1 transaction day = 1 db = 1 odbc.

So i have create so many odbc connection which is impossible.

Is there any way to automatically change db3 file without create odbc for each db3 file?