kettle simple-jndi configuration center

jdbc.properties configuration
SampleData/type=javax.sql.DataSource
SampleData/driver=org.h2.Driver
SampleData/url=jdbc:h2:file:./samples/db/sampledb;IFEXISTS=TRUE
SampleData/user=PENTAHO_USER
SampleData/password=PASSWORD
SampleDataAdmin/type=javax.sql.DataSource
SampleDataAdmin/driver=org.h2.Driver
SampleDataAdmin/url=jdbc:h2:file:./samples/db/sampledb;IFEXISTS=TRUE
SampleDataAdmin/user=PENTAHO_ADMIN
SampleDataAdmin/password=PASSWORD
Quartz/type=javax.sql.DataSource
Quartz/driver=org.hsqldb.jdbcDriver
Quartz/url=jdbc:hsqldb:hsql://localhost/quartz
Quartz/user=pentaho_user
Quartz/password=password
Hibernate/type=javax.sql.DataSource
Hibernate/driver=org.hsqldb.jdbcDriver
Hibernate/url=jdbc:hsqldb:hsql://localhost/hibernate
Hibernate/user=hibuser
Hibernate/password=password
Shark/type=javax.sql.DataSource
Shark/driver=org.hsqldb.jdbcDriver
Shark/url=jdbc:hsqldb:hsql://localhost/shark
shark/user=sa
Shark/password=
PDI_Operations_Mart/type=javax.sql.DataSource
PDI_Operations_Mart/driver=org.postgresql.Driver
PDI_Operations_Mart/url=jdbc:postgresql://localhost:5432/hibernate?searchpath=pentaho_operations_mart
PDI_Operations_Mart/user=hibuser
PDI_Operations_Mart/password=password



#oceanbase database jndi configuration:
# oceanbase_LOCAL localhost
oceanbase_LOCAL/type=javax.sql.DataSource
oceanbase_LOCAL/driver=com.alipay.oceanbase.jdbc.Driver
oceanbase_LOCAL/url=jdbc:oceanbase://192.168.56.111:2883/oceanbase?useUnicode=true &characterEncoding=utf-8 &rewriteBatchedStatements=true &allowMultiQueries=true
oceanbase_LOCAL/user=root@tenantfish
oceanbase_LOCAL/password=



#DB2 database jndi configuration:
#DB_LOCAL localhost
DB_LOCAL/type=javax.sql.DataSource
DB_LOCAL/driver=com.ibm.db2.jcc.DB2Driver
DB_LOCAL/url=jdbc:db2://192.168.56.22:50010/jamy
DB_LOCAL/user=db2inst1
DB_LOCAL/password=1qaz@09876!@#$





#DM database jndi configuration:
# DM_LOCAL localhost
DM_LOCAL/type=javax.sql.DataSource
DM_LOCAL/driver=dm.jdbc.driver.DmDriver
DM_LOCAL/url=jdbc:dm://192.168.56.15:5237
DM_LOCAL/user=SYSDBA
DM_LOCAL/password=SYSDBA






#postgresql database jndi configuration:
# postgresql localhost
postgresql_LOCAL/type=javax.sql.DataSource
postgresql_LOCAL/driver=org.postgresql.Driver
postgresql_LOCAL/url=jdbc:postgresql://192.168.56.15:5432/sales_db?searchpath=pentaho_dilogs
postgresql_LOCAL/user=sales_user
postgresql_LOCAL/[email protected]


 
#mysql database jndi configuration:
# mysql localhost
MYSQL_LOCAL/type=javax.sql.DataSource
MYSQL_LOCAL/driver=com.mysql.cj.jdbc.Driver
MYSQL_LOCAL/url=jdbc:mysql://192.168.56.19:3306/GDP?useUnicode=true &characterEncoding=utf8 &useSSL=false &serverTimezone=GMT
MYSQL_LOCAL/user=root
MYSQL_LOCAL/[email protected]

 
#ORACLE database jndi configuration:
# oracle localhost
ORACLE_LOCAL/type=javax.sql.DataSource
ORACLE_LOCAL/driver=oracle.jdbc.driver.OracleDriver
ORACLE_LOCAL/url=jdbc:oracle:thin:@192.168.56.15:1521:ORCLCDB
ORACLE_LOCAL/user=C##ROOTUSER
ORACLE_LOCAL/password=1qaz@0987654321

 
 
#sqlserver database jndi configuration:
##sqlserver_local
sqlserver/type=javax.sql.DataSource
sqlserver/driver=com.microsoft.sqlserver.jdbc.SQLServerDriver
sqlserver/url=jdbc:sqlserver://192.168.121.130;DatabaseName=jiradb
sqlserver/user=sa
sqlserver/password=Aa123456789
 

#Do the following for the parameters in jdbc.properties:
 #type: The value of this property is always javax.sql.DataSource
  #driver: implements the Driver class in jdbc, the full name of the JDBC driver class
  # url: JDBC URL connection string
  # user: database user name
  # password: database password
  # "/" is the JNDI connection name, this requirement is unique
#ck/type=javax.sql.DataSource
#ck/driver=ru.yandex.clickhouse.ClickHouseDriver
#ck/url=jdbc:clickhouse://1.2.1.4:8123/dbname?socket_timeout=600000
#ck/user=gesaas
#ck/password=123456

#greenplum database jndi configuration:
#greenplum_local
greenplum/type=javax.sql.DataSource
greenplum/driver=com.pivotal.jdbc.GreenplumDriver
greenplum/url=jdbc:pivotal:greenplum://192.168.56.16:5432;DatabaseName=postgres
greenplum/user=gpadmin
greenplum/password=greenplum




#gbase database jndi configuration:
#gbase_LOCAL
gbase_LOCAL/type=javax.sql.DataSource
gbase_LOCAL/driver=com.gbasedbt.jdbc.Drive
gbase_LOCAL/url=jdbc:gbasedbt-sqli://192.168.56.116:9088/testdb:GBASEDBTSERVER=gbase01
gbase_LOCAL/user=gbasedbt
gbase_LOCAL/password=GBase123
#kingbase
kingbase_LOCAL/type=javax.sql.DataSource
kingbase_LOCAL/driver=com.kingbase8.Driver
kingbase_LOCAL/url=jdbc:kingbase8://192.168.56.117:54321/test?zeroDateTimeBehavior=convertToNull &useUnicode=true &characterEncoding=utf-8
kingbase_LOCAL/user=SYSTEM
kingbase_LOCAL/password=SYSTEM
#OceanBase database jndi configuration: