SDA - Remote objects limit (1000) reached

[ashokkumar_n2]

Hi All,

Here I am going to explain, how to create a virtual table using SDA(Smart Data Access) in HANA studio.

Once the Remote system is configured under SDA, Under 'Remote sources' we can see the list of tables from the source system(PFB screen shot). When you open any schema, only 1000 tables will be displayed and at the end, you get an message 'Remote objects limit (1000) reached'  and we don't have any filter option here to select a particular table.



So now, there are three ways to create a virtual table(If we can't see the required table in that list displayed).

1) Increasing the limit of 'Maximum number of Remote objects to be displayed'
2) Create Virtual table directly in the schema(Under Catalog)
3) Use SQL to create the virtual table.

I will be explaining step 1 and 2 here.

1) Increasing the limit of 'Maximum number of Remote objects to be displayed'

Follow the below mentioned path in HANA studio.

System Monitor-->Configuration-->indexserver.ini--> smart_data_access--> remote_objects_tree_max_size

If this parameter is not available, Right click on the smart_data_access-->Add Parameter



Once the above configuration is maintained, all the tables will be displayed. Then it is possible to create Virtual table by right clicking on any table.

2) Create Virtual table directly in the schema(Under Catalog)

We can directly create Virtual table using this option. Filter option also available here 🙂

a) Under Catalog open any schema where you want to create the virtual table
b) Right click on the Tables and select 'New Virtual Table'



c) Give a name for the Virtual table and click 'Browse'
d) Give the table name you want to see, in the filter and open the schema(Note:Do not open the schema with out giving filter)



e)Select the required table, click OK, Execute/Save

A new virtual table is created under the selected schema.

Thank you.

Ashok.N