Tableau Data Connection to Firebird for Country-level data

Country.xml

<?xml version='1.0' encoding='utf-8' ?>

<datasource formatted-name='Country' inline='true' version='9.2' xmlns:user='http://www.tableausoftware.com/xml/user'>
  <connection class='firebird' dbname='GEOCODING.FDB' local-data='standard' username='sysdba'>
    <relation join='inner' type='join'>
      <clause type='join'>
        <expression op='AND'>
          <expression op='='>
            <expression op='[Country].[ID]' />
            <expression op='[LocalData].[ParentID]' />
          </expression>
          <expression op='='>
            <expression op='[Country].[MapCode]' />
            <expression op='[LocalData].[MapCode]' />
          </expression>
        </expression>
      </clause>
      <relation join='inner' type='join'>
        <clause type='join'>
          <expression op='AND'>
            <expression op='='>
              <expression op='[Country].[ID]' />
              <expression op='[CountrySynonyms].[ParentID]' />
            </expression>
            <expression op='='>
              <expression op='[Country].[MapCode]' />
              <expression op='[CountrySynonyms].[MapCode]' />
            </expression>
          </expression>
        </clause>
        <relation name='Country' table='[Country]' type='table' />
        <relation name='CountrySynonyms' table='[CountrySynonyms]' type='table' />
      </relation>
      <relation name='LocalData' table='[LocalDataCountry]' type='table' />
    </relation>
    <cols>
      <map key='[CountrySynonyms_MapCode]' value='[CountrySynonyms].[MapCode]' />
      <map key='[CountrySynonyms_ParentID]' value='[CountrySynonyms].[ParentID]' />
      <map key='[Country_FIPS]' value='[Country].[FIPS]' />
      <map key='[Country_ISO3166_2]' value='[Country].[ISO3166_2]' />
      <map key='[Country_ISO3166_3]' value='[Country].[ISO3166_3]' />
      <map key='[Country_MapCode]' value='[Country].[MapCode]' />
      <map key='[Country_Name]' value='[CountrySynonyms].[Name]' />
      <map key='[Country_ParentID]' value='[Country].[ParentID]' />
      <map key='[Geometry (generated)]' value='[LocalData].[Geometry]' />
      <map key='[ID]' value='[Country].[ID]' />
      <map key='[IsDisplayName]' value='[CountrySynonyms].[IsDisplayName]' />
      <map key='[Latitude (generated)]' value='[LocalData].[Latitude]' />
      <map key='[Locale]' value='[CountrySynonyms].[Locale]' />
      <map key='[Longitude (generated)]' value='[LocalData].[Longitude]' />
      <map key='[MapCode]' value='[LocalData].[MapCode]' />
      <map key='[ParentID]' value='[LocalData].[ParentID]' />
    </cols>
  </connection>
  <aliases enabled='yes' />
  <column datatype='integer' hidden='true' name='[CountrySynonyms_MapCode]' role='dimension' type='quantitative' />
  <column aggregation='Sum' datatype='integer' name='[CountrySynonyms_ParentID]' role='dimension' type='ordinal' />
  <column datatype='string' name='[Country_FIPS]' role='dimension' type='nominal'>
    <server-captions>
      <caption locale='en_US'>Country (FIPS 10)</caption>
    </server-captions>
  </column>
  <column datatype='string' name='[Country_ISO3166_2]' role='dimension' type='nominal'>
    <server-captions>
      <caption locale='en_US'>Country 2 char (ISO 3166-1)</caption>
    </server-captions>
  </column>
  <column datatype='string' name='[Country_ISO3166_3]' role='dimension' type='nominal'>
    <server-captions>
      <caption locale='en_US'>Country 3 char (ISO 3166-1)</caption>
    </server-captions>
  </column>
  <column datatype='integer' hidden='true' name='[Country_MapCode]' role='dimension' type='quantitative' />
  <column datatype='string' name='[Country_Name]' role='dimension' type='nominal'>
    <server-captions>
      <caption locale='en_US'>Country (Name)</caption>
    </server-captions>
  </column>
  <column datatype='integer' hidden='true' name='[Country_ParentID]' role='measure' type='quantitative' />
  <column caption='Geometry (generated)' datatype='string' name='[Geometry (generated)]' role='dimension' semantic-role='[Geographical].[Geometry]' type='nominal' />
  <column aggregation='Sum' datatype='integer' hidden='true' name='[ID]' role='dimension' type='ordinal' />
  <column aggregation='Avg' datatype='real' name='[Latitude (generated)]' role='measure' semantic-role='[Geographical].[Latitude]' type='quantitative'>
    <server-captions>
      <caption locale='en_US'>Latitude (generated)</caption>
    </server-captions>
  </column>
  <column aggregation='Avg' datatype='real' name='[Longitude (generated)]' role='measure' semantic-role='[Geographical].[Longitude]' type='quantitative'>
    <server-captions>
      <caption locale='en_US'>Longitude (generated)</caption>
    </server-captions>
  </column>
  <column datatype='integer' hidden='true' name='[MapCode]' role='dimension' type='quantitative' />
  <column datatype='integer' name='[Number of Records]' role='measure' type='quantitative' user:auto-column='numrec'>
    <calculation class='tableau' formula='1' />
  </column>
  <column aggregation='Sum' datatype='integer' hidden='true' name='[ParentID]' role='dimension' type='ordinal' />
  <layout dim-ordering='alphabetic' dim-percentage='0.5' measure-ordering='alphabetic' measure-percentage='0.4' show-structure='true' />
</datasource>