I would like use ArcGIS Data Store for my services, and I am wondering if there is any way to create a Database connection from ArcCatalog or ArcMap to the PostgreSQL database?
Yes, but I don't have much experience working with PostgreSQL database. I installed pgAdmin III on the same machine as I have ArcGIS Data Stored installed. When I tried to add this server to the pgAdmin III, I am getting following error:
The server doesn't accept connections: the connection library reports:
"could not connect to server: connection refused (0x0000274D/10061) Is the server running on host "XXX.XXX.XXX.XXX" and accepting TCP/IP connection on port 5432"
Is there something I need to do first to connect to the PostgreSQL database?
What are you interested in seeing when you connect to Data Store directly? The Data Store is designed so you don't really need to connect to it to perform any maintenance or anything like that, so it'd be good to know your use case for connecting.
I would like to connect the database directly to generate reports using Crystal Report or JasperReport, and extract data for dashboard analytics.
Thanks.