We will start from the very ground up, build a simple dashboard and then enhance the functionality of our dashboard gradually.
If you have already installed and configured InfoCaptor then you may skip the below section
How to install
- Download the setup file from this location, if you are somehow restricted from downloading and installing any new software or do not have the rights then you may alternatively use this web version of InfoCaptor.
- Double click on the setup file and let the install program run
- Once installed completely, launch InfoCaptor
How to connect to database
Now we need to establish a database connection. The database could be the one running on your PC or the one running on a server. InfoCaptor is designed and built using Java and uses JDBC protocol to connect to database and so it can connect to any database. As you can see below it supports a wide variety of databases.
InfoCaptor comes packaged with the Oracle JDBC driver so there is no additional step required for it to work with Oracle databases. But if you need to work with MySQL or MS SQL Server or DB2 or other vendor databases then you may obtain the necessary JDBC driver ( it is usually one file with .jar extension). Download the jdbc jar file and then copy this jar file in the following location “C:Program FilesInfoCaptorjre1.5.0_06libext” and then launch InfoCaptor. You are now ready to connect to the database.
For any connection you need the following items
Host, Port, SID, username and password.
If you are not sure about any of the above then please consult your Database administrator
Typical values for the above are “localhost”, “1521”, “orcl”, “system”, “welcome” respectively.
Once you have entered all the values, hit the connect button. If the connection is successful then the connection wizard closes else it will show the appropriate failure message.
This completes the basic installation and setup