Sources : Odata, how to set up the connector

AntoineSy

Hello everyone, First post from Antoine at Symbiotics Geneva.
Glad to find out that the AC community is growing !
I have more and more request to pull data in my ODS through an odata endpoint.
Is it possible to use directly AC to get this data ? Is it possible to walk me through the connector set up ?
My hopes are high as I see an option to use "odata" in the Azure Source Type parameter.

Thanks

DimitriSorokin

Hello Antoine,

To access ODATA services you can use ODATA ODBC driver of CDATA.
There is one known issue with this ODBC driver - sometme the nvarchar field imported by this driver have length greather than 4000 characters.
You should correct such fields in AnalyticsCreator and set the length to 4000.

Other way to import data from ODATA service is to use "Externally Filled Tables" in AnaltticsCreator and to develop your own interface/application to fill up these tables.