Hello,
I have enabled federation to Teradata on BigSQL and trying to use Oracle SQL developer tool to access BigSQL tables. But, I'm not able to see the federated tables (nicknames) in the Connections and Reports navigator pane. ( see attached picture )
1. Expecting my federated tables to be populated under 'Tables' or the ability to create a 'Nickname' object and list all the federated tables
2. 'foo' is my federated table which I can query, but not able to see it visually.
My select output from syscat.tables in BigSQL:
db2 "select tabname from syscat.tables where tabschema='BIGSQL'"
TABNAME
--------------------------------------------------------------------------------------------------------------------------------
FOO
T1
db2 list tables
Table/View Schema Type Creation time
------------------------------- --------------- ----- --------------------------
FOO BIGSQL N 2018-08-01-14.30.33.021454
T1 BIGSQL T 2018-06-27-12.43.39.571532
2 record(s) selected.
Please let me know whether this is a product limitation or something I'm missing in configuration.
Thanks