Welcome to Knowage Q&A, where you can ask questions and receive answers from other members of the community.

Categories

Most popular tags

cockpit dataset error chart datasource installer datasets installation widget parameters business-model olap knowage knowage_7_1 integration login knowage_7_1-ce report-designer cross-navigation analyticaldriver

How to define Data Source for MS Access database

0 votes
1 view
Dear Experts,

I have MS Access database where my data is available for analytics, I want to connect the Knowage with MS Access please guide me how can I connect with it. I have connected with Oracle and it is working fine using JDBC connection setting in data source.

Thanks.
in Data Source by (860 points)

1 Answer

+1 vote
 
Best answer
Dear,

You should  find jdbc driver for MS Access.

But I suggest to use a real BDSM system, would you consider to import data from Access to Oracle ?

Best Regards

Angelo
by (20.7k points)
selected by
Powered by Question2Answer
...