Example
This is an example of a named table definition for a PostgreSQL/PostGIS database table, using the PostGIS data provider.
In this example, the definition defines a connection to a PostGIS database table using the following tokens:
-
@jdbcurl@ the jdbc url used to connect to the database, which is of the form
jdbc:postgresql://@host@:@port@/@databasename@ - @host@ the host name used to connect to the database
- @port@ the port number used to connect to the database
- @databasename@ the name for the instance
- @user@ the user name credentials to access the table
- @password@ the password credentials for accessing the database
- @table@ the name of the table in the database
- @schema@ the schema used by the database. For example: public
- @named_connection_path@ the name of the named connection with path in the repository
<?xml version="1.0" encoding="UTF-8"?>
<NamedDataSourceDefinition version="MXP_NamedResource_1_5" xmlns="http://www.mapinfo.com/mxp">
<ConnectionSet>
<NamedConnectionRef resourceID="@named_connection_path@">
<ConnectionName>Connection_1</ConnectionName>
</NamedConnectionRef>
</ConnectionSet>
<DataSourceDefinitionSet>
<DBDataSourceDefinition id="dbDataSourceDef1" volatile="true">
<DataSourceName>PostgresqlDataSource</DataSourceName>
<ConnectionMember>
<ConnectionName>Connection_1</ConnectionName>
</ConnectionMember>
<DBTable owner="@schema@" useQuotes="true">@table@</DBTable>
</DBDataSourceDefinition>
</DataSourceDefinitionSet>
<DataSourceRef ref="dbDataSourceDef1"/>
</NamedDataSourceDefinition>