Publish a Service With Non -Geo Database table data

LPKKaru

Hi all,

I am .net developer and have the GIS background knowledge.
I am currently working with java script API and need to integrate  our client sales data with the esri map.

They have bought arc gis server and i m currently playing with evaluation ARC GIS server.

i create two database connections via Arc catalog for both data bases. no luck after that to my task.

If some one encounter this problem early PLEASE Help me on this.
If you can give me steps to get there please advice and the help is highly appreciated.

i m using arc GISserver 10.2
SQL server 2008 R2 


Thank you.

LPKKaru

Thank you Marco Boeringa,

I followed your instructions.

Created a data base  view
Added query layer to the map and query layer connects with data base view.
And published the service and has the new view in the service directory Under the Table category.

Now i need popup window in each retailer location with the data from my Table using java script api.

How can i access the table data in the points layer info window .


Thanks.
Regards!