How to register a pushdown function for JDBC connector.

[shekhar78]

Hi,

I have a JDBC driver  which supports a function ABC in its query (pushdown function) and can handle it to extract information from datasource.

I  configure a datasource connection with above driver using TEIID inbuilt JDBC-connector. It works fine but whenever I use the pushdown function ABC in query it doesn't send it to the driver and deteriorates performance.

Is there any way configure the jdbc connector to recognize ABC as a pushdown function?

Thanks

Shekhar

[rareddy]

Shekhar,

How did you define the function "ABC"with data source connection?

You need to define function "ABC" on the physical model that representing data source in the VDB. Only functions defined on source models and functions defined as system/pushdown functions on translator are eligible for pushdown.

Ramesh..