How to import Fortigate logs into Qlikview

Hi Experts,

I am trying to export Fortigate firewall logs and QLikview retrieve them. Is there any way that Qlikview can retrieve the Database of the Fortigate to pull out those logs?
Please advise
chenzoviccAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

RobOwner (Aidellio)Commented:
it really depends on the file format but If it can't do it directly then the wizard should be able to parse the data. Do you have a sample log file I could test with?
0
chenzoviccAuthor Commented:
Thanks for your reply but I can't provide a sample file cause is company policy. I notice that when I export it manually is a log file which I tried to open in excel and I can see all the information. One of my co-workers made it delimited to be able to sort it out by columns.
Will QLikview able to import that data if I export it somewhere in  a folder?
0
RobOwner (Aidellio)Commented:
Will QLikview able to import that data if I export it somewhere in  a folder?
based on what you said regarding excel, yes it will be able to import it.
If you have odbc access to the database it could access directly
0
RobOwner (Aidellio)Commented:
I'm looking through the fortigate manual: http://docs.fortinet.com/uploaded/files/1048/fortigate-loggingreporting-40-mr3.pdf 

Page 17: The SQLite log database

Qlikview will be able to connect to this via an ODBC driver (e.g. http://www.ch-werner.de/sqliteodbc/).  Use the wizard in your QV script to connect to it and you'll see all the tables in the database.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
chenzoviccAuthor Commented:
We have a Qlikview person and I will ask him base on the information you provided. Thanks a lot.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
DB Reporting Tools

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.