Laserfiche WebLink
Generic Database Data s tore <br /> Appendix – Generic Datab ase Data s tore - 3 <br />The DatabaseEngine can be one of the following values, and is used to control internal database <br />interactions: <br /> <br />• Access – Mi crosoft Access database <br />• Excel – Microsoft Excel workbook (first row of worksheet should be the column names, <br />column types are determined by scanning rows (independent of the Rows to Scan value in the <br />ODBC DNS setup); refer to sheet in SQL as “Select * from [Sheet1$]” ) <br />• H2 – H2 database <br />• Informix – INFORMIX database <br />• MySQL – MySQL database <br />• Oracle – Oracle database <br />• PostgreSQL – PostgreSQL database <br />• SQLServer – Microsoft SQL Server database <br /> <br />TSTool, which is written in Java, is distributed with the software driv ers for the above databases only if <br />datastores have been implemented that use a database product. For example, the State of Colorado’s <br />HydroBase database is implemented in SQL Server and consequently the SQL Server driver is distributed <br />with TSTool. Othe r drivers (e.g., Access via ODBC ) depend on installation of the database software, <br />which typically includes the ODBC drivers. Some of the databases listed above have only been used in <br />development and software support may be out of date. If in doubt, cont act the software developers and <br />the issue will be evaluated. More databases can be supported if the number of users increases. <br /> <br />The following example illustrates how to configure a datastore for an ODBC DSN connection to an <br />Access database: <br /> <br /># Configurati on information for Nebraska DNR development database. <br /># Properties are: <br /># <br /># The user will see the following when interacting with the datastore: <br /># <br /># Type - required to be GenericDatabaseDataStore <br /># Name - datastore identifier used in applications, for exam ple as the <br /># input type information for time series identifiers (usually a short string) <br /># Description - datastore description for reports and user interfaces (short phrase) <br /># DatabaseEngine - the database software <br /># OdbcName - the Open Database Connec tivity Data Source Name (ODBC DSN), configured <br /># in Windows Control Panel <br /># <br /> <br />Type = "GenericDatabaseDataStore" <br />Name = "ElSalvador" <br />Description = "El Salvador Datab ase" <br />DatabaseEngine = "Access" <br />OdbcName = "ElSalvador" <br />Generic Database Datastore Config uration File Using ODBC DSN Properties <br /> <br />29