Select to view content in your preferred language

Is there a way to reference feature classes and data fields from multiple database in Attribute Rules?

189
5
3 weeks ago
AbiDhakal
Occasional Contributor III

Hello GIS friends,

Is there a way to reference feature classes and data fields from multiple enterprise geodatabase or sql  database within an Attribute Rule.

I would like to establish an attribute rule capable of retrieving field information from another database to populate feature class in a separate geodatabase. Is this possible?

I will appreciate your help.

Thank you,
Abi

0 Kudos
5 Replies
Jake_S
by Esri Contributor
Esri Contributor

@AbiDhakal it is not possible to access data from another database. All data must reside in the same data source as the feature you are applying the rule too.

The best way to handle this is to create a view in the same database as your feature, register that view with the database and then you can access that data via attribute rule. 

Hope This helps.

~Jake

AbiDhakal
Occasional Contributor III

@Jake_S- That sounds like a plan, but how can I create a view in the same database?

Thank you,
Abi

0 Kudos
Jake_S
by Esri Contributor
Esri Contributor

There is a geoprocessing tool Create Database View (Data Management) it requires some SQLl statement knowledge. If you have a DBA they can also assist.

~Jake

AbiDhakal
Occasional Contributor III

@Jake_SI think you are suggesting to join the features based on a common field to create a view. I'm thinking we could also do this from SQL Server Management Studio...

Thank you for your input.
Abi

0 Kudos
Jake_S
by Esri Contributor
Esri Contributor

@AbiDhakal You can absolutely create views there. There are some requirements needed to register a view with a geodatabase.

You can find all the information here,  Register a table or view with the geodatabase.

~Jake