Skip to main content

Pentaho+ documentation has moved!

The new product documentation portal is here. Check it out now at docs.hitachivantara.com

 

Hitachi Vantara Lumada and Pentaho Documentation

databaseConnection

Overview

Explains what the feature is or what its benefits are to the user or customer.

Feature

databaseConnection element

Type: databaseConnection

Example XML

<?xml version="1.0" encoding="UTF-8"?>
<databaseConnection>
  <attributes>
    <entry>
      <key>...</key>
      <value>...</value>
    </entry>
    <entry>
      <key>
        <!--(another 'string' type)-->
      </key>
      <value>
        <!--(another 'string' type)-->
      </value>
    </entry>
    <!--...more entries...-->
  </attributes>
  <maximumPoolSize>...</maximumPoolSize>
  <databaseName>...</databaseName>
  <accessTypeValue>...</accessTypeValue>
  <quoteAllFields>...</quoteAllFields>
  <databaseType>
    <shortName>...</shortName>
    <defaultDatabasePort>...</defaultDatabasePort>
    <name>...</name>
    <extraOptionsHelpUrl>...</extraOptionsHelpUrl>
    <supportedAccessTypes>...</supportedAccessTypes>
    <supportedAccessTypes>
      <!--...-->
    </supportedAccessTypes>
    <!--...more "supportedAccessTypes" elements...-->
  </databaseType>
  <username>...</username>
  <password>...</password>
  <accessType>...</accessType>
  <forcingIdentifiersToUpperCase>...</forcingIdentifiersToUpperCase>
  <informixServername>...</informixServername>
  <forcingIdentifiersToLowerCase>...</forcingIdentifiersToLowerCase>
  <dataTablespace>...</dataTablespace>
  <changed>...</changed>
  <hostname>...</hostname>
  <id>...</id>
  <connectSql>...</connectSql>
  <extraOptions>
    <entry>
      <key>...</key>
      <value>...</value>
    </entry>
    <entry>
      <key>
        <!--(another 'string' type)-->
      </key>
      <value>
        <!--(another 'string' type)-->
      </value>
    </entry>
    <!--...more entries...-->
  </extraOptions>
  <streamingResults>...</streamingResults>
  <partitioned>...</partitioned>
  <indexTablespace>...</indexTablespace>
  <usingDoubleDecimalAsSchemaTableSeparator>...</usingDoubleDecimalAsSchemaTableSeparator>
  <initialPoolSize>...</initialPoolSize>
  <partitioningInformation>
    <password>...</password>
    <hostname>...</hostname>
    <partitionId>...</partitionId>
    <databaseName>...</databaseName>
    <username>...</username>
    <port>...</port>
  </partitioningInformation>
  <partitioningInformation>
    <!--...-->
  </partitioningInformation>
  <!--...more "partitioningInformation" elements...-->
  <name>...</name>
  <usingConnectionPool>...</usingConnectionPool>
  <connectionPoolingProperties>
    <entry>
      <key>...</key>
      <value>...</value>
    </entry>
    <entry>
      <key>
        <!--(another 'string' type)-->
      </key>
      <value>
        <!--(another 'string' type)-->
      </value>
    </entry>
    <!--...more entries...-->
  </connectionPoolingProperties>
  <databasePort>...</databasePort>
  <SQLServerInstance>...</SQLServerInstance>
</databaseConnection>

Example JSON

{
  "attributes" : {
    "..." : "...",
    "---" : ...
  },
  "maximumPoolSize" : ...,
  "databaseName" : "...",
  "accessTypeValue" : "...",
  "quoteAllFields" : false,
  "databaseType" : {
    "shortName" : "...",
    "defaultDatabasePort" : ...,
    "name" : "...",
    "extraOptionsHelpUrl" : "...",
    "supportedAccessTypes" : [ "NATIVE", ... ]
  },
  "username" : "...",
  "password" : "...",
  "accessType" : "NATIVE",
  "forcingIdentifiersToUpperCase" : false,
  "informixServername" : "...",
  "forcingIdentifiersToLowerCase" : false,
  "dataTablespace" : "...",
  "changed" : false,
  "hostname" : "...",
  "id" : "...",
  "connectSql" : "...",
  "extraOptions" : {
    "..." : "...",
    "---" : ...
  },
  "streamingResults" : false,
  "partitioned" : false,
  "indexTablespace" : "...",
  "usingDoubleDecimalAsSchemaTableSeparator" : false,
  "initialPoolSize" : ...,
  "partitioningInformation" : [ {
    "password" : "...",
    "hostname" : "...",
    "partitionId" : "...",
    "databaseName" : "...",
    "username" : "...",
    "port" : "..."
  }, ... ],
  "name" : "...",
  "usingConnectionPool" : false,
  "connectionPoolingProperties" : {
    "..." : "...",
    "---" : ...
  },
  "databasePort" : "...",
  "SQLServerInstance" : "..."
}

Copyright © Pentaho.com