How to connect local database?
Hi All
I am just new to the Zoho reports. Can any one tell me how to connect the local database - oracle.
I have configured the below in the config files.
# $Id$
DBTYPE=ORACLE
HOSTNAME=localhost
PORT=1521
USERNAME=hr
PASSWORD=hr
DBNAME=ORCL
#MDBFILENAME=
#SQLITEFILENAME=
#FIREBIRDFILENAME=
# Generic JDBC connection properties: To upload from a unsupported local database which has a JDBC connector / driver:
# Below properties should be used in this case. It is enough to provide the value for DBTYPE, DRIVERCLASSNAME and CONNECTIONURL
# to connect a unsupported local database from upload tool. If username and password is not specified as part of the CONNECTIONURL
# then please specify it in the properties USERNAME and PASSWORD. DBTYPE can be the name of your local database say Progress( OpenEdge ) DB
#DRIVERCLASSNAME=
#CONNECTIONURL=
Database_SQL_Queries:
<?xml version="1.0" encoding="UTF-8" ?>
<!-- $Id$ -->
<Queries>
<!-- Specify select query if database type is other than mongodb -->
<Query dbname="orcl" tablename="employees" importtype="APPEND" matchingcols="" selectcols="" skiptop="">
select * from employees
</Query>
</Queries>
I am getting the below error:
The system cant find the file specified.
Thanks