Controlling Which Datasources Are Geospatial Enabled
After you create the geospatial tables in the database, there is nothing else you need to do in order to geospatial enable a datasource. However, if you want some of your datasources to be geospatial enabled and some not, or if you want to prevent the geospatial tables from being created in a particular datasource, then you must do some configuration in the ProjectWise Design Integration Server's DMSKRNL.CFG file located in the ...\ProjectWise\bin folder.
At the bottom of the DMSKRNL.CFG file is a list of all the datasources running on this server with headings [db0], [db1], [db2], and so on, where [db0] represents the first datasource created, [db1] the second, [db2] the third, and so on. Information provided includes datasource display name, description, name of ODBC datasource used, type of database used, and username and password for database user and admin user. This information is added to the file when the datasource is created.
For each datasource that you want geospatial functionality to be enabled, add the line:
GeoDatasource = True
For each datasource that you want geospatial functionality to be disabled, add the line:
GeoDatasource = False
For example:
[db0] DBUsrPwdDecrypt=4 InterfaceType=ODBC Type=Microsoft SQL Server DBUserName=sa DBUserPassword=#x/e62eidKOstv1Y0HZoMyX3VFrLe/kdFukTd/qxRyLmLw1G5 Description=GSSDemo Name=GSSDemo GeoDatasource = True [db1] DBUsrPwdDecrypt=4 InterfaceType=ODBC Type=Microsoft SQL Server DBUserName=sa DBUserPassword=#x/e62eidKOstv1Y0HZoMyX3VFrLe/kdFukTd/qxRyLmLw1G5 Description=Test Name=Test GeoDatasource = False
When you disable geospatial functionality for a datasource, you will not be prompted to create the geospatial tables in the database, and no geospatial nodes will display in ProjectWise Administrator; in other words, the geospatial functionality will not be available in that datasource. Disabling geospatial functionality in a datasource does not remove geospatial tables from the database if they were already created.
Change the line from GeoDatasource = False to GeoDatasource = True if you want to enable geospatial functionality in a datasource where it was previously disabled.
When you enable geospatial functionality for an existing datasource that does not yet have the geospatial database tables, you will be prompted to create the geospatial database tables the next time you log in to that datasource in ProjectWise Administrator.
You can also use a global setting to either enable or disable geospatial functionality for all datasources on this server, and then use the datasource level setting to explicitly enable or disable geospatial functionality on a per-datasource basis.
For example, add this global setting to disable geospatial functionality for all datasources of this server:
[Geocfg] GeoDatasource = False
Next, add the GeoDatasource = True line to the bottom of only the datasources for which you want to enable geospatial functionality:
[db0] DBUsrPwdDecrypt=4 InterfaceType=ODBC Type=Microsoft SQL Server DBUserName=sa DBUserPassword=#x/e62eidKOstv1Y0HZoMyX3VFrLe/kdFukTd/qxRyLmLw1G5 Description=GSSDemo Name=GSSDemo GeoDatasource = True