Welcome to Knowage Q&A, where you can ask questions and receive answers from other members of the community.
+1 vote
1 view
Hi, I want to know how can i get data from external sources and how configure it to do it. Thank you!
in Data Source by (130 points)

1 Answer

+1 vote

Hi. What do you mean exactly by external sources?

You can connect to databases to which you have access to. In order to do that you have to:

  • add resource tag in %knowage%\conf\server.xml file
%knowage% - is you base knowage installation folder

just open server.xml and add something like that (with actual data, this is postgres db example):

<Resource name="jdbc/resourceName" auth="Container"
          type="javax.sql.DataSource" driverClassName="org.postgresql.Driver"
          url="jdbc:postgresql://localhost:1111/databaseName"
          username="user" password="pswd" maxActive="20" maxIdle="10"
          maxWait="-1"/>
  • after that add resource link in contex.xml file for each %knowege%\webapps\knowage... folder

for example %knowage%\webapps\knowagebirtreportengine\META-INF\context.xml
open file and add something like that (with actual data, again it's my postgres example)

<ResourceLink global="jdbc/resourceName" name="jdbc/resourceName" type="javax.sql.DataSource"/>
  • After that you can create datasource in Knowege. And then use datasource you just created to create datasets for reporting purposes.

----

You can also create dataset based on REST API (you don't need to create dataSource in Knowage for that). Just go to data sets -> hit big plus icon to add data set -> hit "type" tab -> choose "REST".

That way you can extract public data from various APIs and use it for reporting purposes.

Regars

by (270 points)
...