Hi
i am trying to configure/setup Teeid 7.7.1(deployed in jboss soa 5.3) to acess my oracle 11 tables(employee) via synonyms(employee_syn). After creating necessary datasource file, vdb file,i am able to fetch the table via select query (select * from employee) using teeid client but when i try to do select on synonym(select * from employee_syn) i am getting below exception.
Pls let me know how to access my tables via synonym in Teeid.
---- vdb file -----
<vdb name="sample_1" version="1">
<property name="UseConnectorMetadata" value="true" />
<model name="sample_1">
<property name="importer.useFullSchemaName" value="false"/>
<property name="importer.tableTypes" value="TABLE,VIEW"/>
<property name="importer.schemaPattern" value="user"/>
<source name="oracle-connector" translator-name="oracle" connection-jndi-name="java:/1-local-oracleDS"/>
</model>
</vdb>
--- ds file ----
<datasources>
<local-tx-datasource>
<user-name>user</user-name>
<password>password</password>
<connection-property name="includeSynonyms">true</connection-property>
<jndi-name>1-local-oracleDS</jndi-name>
<connection-url>jdbc:oracle:thin:@localhost:1521/XE</connection-url>
<driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
<min-pool-size>5</min-pool-size>
<max-pool-size>20</max-pool-size>
<idle-timeout-minutes>0</idle-timeout-minutes>
<track-statements/>
<prepared-statement-cache-size>32</prepared-statement-cache-size>
<metadata>
<type-mapping>Oracle9i</type-mapping>
</metadata>
</local-tx-datasource>
</datasources>
--- exception ----
group employee_syn not found
See also https://community.jboss.org/thread/220324
At the least the importer.tableTypes must include SYNONYM. I'll also try to verify this scenario on my side as well, since this seems like a popular topic.
Steve