I am trying to make a non geographic table available to a map service. I thought you simply added the table to the MXD and publish it with a relate to the field they were linked and then publish the service, where the data would be available as a table layer. I have done this, and only the geographic data is shown as an available layer. Am I missing a step?
I now know, I do not want a Join or relate; I want the table to available via a query on the table.
OK, there seems to be a few issues here.
We are using a direct connect, and this needs Oracle Client installed on the ArcGIS Server. The SOC and SOM accounts were a red herring. If we're going straight through the SDE connection port, then you don't need the client, but as we're going through to the db, i.e. using 2 tier architecture, rather than 3 tier, then we need the client.
So we're installing the client on the server, as we've never directly connected before, and I'll post the results. But now, looking back on it, it all seems logical really, as we're bypassing the SDE layer
This is for a Web application, so the data is exposed via REST on the 'net
I am actually not too sure it is possible, which is very odd...
Just to ensure I am not going mad, and am doing this all the right way; I am creating an MXD, adding a featurelayer to it, then adding a 'flat' table (no geo data), saving it and serving it up on the ArcGIS server. when I do, all of the features display, but querying the Rest interface tells me there are no tables, just this one polygon layer.
That's all cool isn't it? I am not insane?