SQL Azure indexer support for Collection(Edm.String)
Currently migrating from FTS to Azure search. While in preview we setup our indexes with collections for some one to many data types (phone numbers, addresses, etc...) It would be nice to realize these collections with an indexer.. As far as the structure of the column we don't really have an existing structure in our system so we'd just build it based on what made the most sense for the way you process data.. I realize fundamentally that type of structure in SQL is unnatural so there's probably not something that just naturally fits. Possibly XML?
-JSON (since DocDb supports maybe this will be easy to implement) but since JSON isn't really a natural SQL concept might be a bad way to go
-Allow user to specify delimiter and use backslash to escape or possibly allow ASCII hexcode representation if the delimiter needs to be part of the search string.
-XML allows for more complex data description.. Maybe as the service grows the XML could include additional meta-data properties?
The JSON array to string collection mapping is available for use now.
We have run into the same issue and it seems to be a blocker for us.
We have Xml data in our database and it needs to be converted to Collection in Azure Search. We can change the Xml to Json data, if jsonArray is enabled.
However as a temporary workaround, is there any way? Shane, did you get any workaround?