Difference between revisions of "Connecting to IMSMA Staging area from ArcGIS"
From IMSMA Wiki
Line 1: | Line 1: | ||
− | To be able to connect to the Staging area from ArcGIS you need to have the client library files: | + | To be able to connect to the Staging area database from ArcGIS you need to have the client library files: |
* libeay32.dll | * libeay32.dll | ||
* libiconv-2.dll | * libiconv-2.dll | ||
Line 8: | Line 8: | ||
[[Image:Staging mxd.png|500px|center]] | [[Image:Staging mxd.png|500px|center]] | ||
− | There is also a special mxd-file, staging.mxd, that contains the IMSMA symbology and has | + | There is also a special mxd-file, staging.mxd, that contains the IMSMA symbology and has Data Source set to a PostgreSQL database called ''''staging'''' for all layers. You find the ''staging-MM-DD-YY.mxd'' in C:\IMSMAETLTool\data. |
− | If your IMSMA Staging area database is called something else than '''staging''', you need to rebuild the | + | If your IMSMA Staging area database is called something else than '''staging''', you need to rebuild the Data Source links for each layer. On ESRI's ArcGIS Resource Center you will find [http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//00s500000020000000| instructions] on how to '''Repair broken links for multiple layers'''. |
{{NavBox Business Intelligence}} | {{NavBox Business Intelligence}} | ||
[[Category:VIE]] | [[Category:VIE]] |
Revision as of 19:40, 14 November 2014
To be able to connect to the Staging area database from ArcGIS you need to have the client library files:
- libeay32.dll
- libiconv-2.dll
- libintl-8.dll
- libpq.dll
- ssleay32.dll
which you may find in C:\IMSMAng\pgsql\bin or download from here.
There is also a special mxd-file, staging.mxd, that contains the IMSMA symbology and has Data Source set to a PostgreSQL database called 'staging' for all layers. You find the staging-MM-DD-YY.mxd in C:\IMSMAETLTool\data.
If your IMSMA Staging area database is called something else than staging, you need to rebuild the Data Source links for each layer. On ESRI's ArcGIS Resource Center you will find instructions on how to Repair broken links for multiple layers.
|