Problems opening sql server Spatial datawith read/write in Bentley Map

Bentley Map will typically use the SQL user credentials you connect with.

Is it an ad-hoc connection or a registered connection within a Bentley Geospatial Administrator .xml schema ?

Regards

This might help you to assign Read/Write permission on SQL spatial database.

Requirements for a Read/Write Connection

A SQL Server table should have a primary key defined to ensure rows can be identified uniquely. The preferred mechanism is to define the primary key column as IDENTITY:->

1. If the primary key column has an IDENTITY specification, then the IDENTITY generator will be used to populate this column with a unique value.
2. If the primary key does not have an IDENTITY specification then :
-> For a numeric primary key Bentley Map will query for the maximum value and increment that by one when adding a new record
-> For other column types Bentley Map will attempt to store the UUID that XFM uses internally.

Regards,
Anupama Joshi

This might help you to assign Read/Write permission on SQL spatial database.

Requirements for a Read/Write Connection

A SQL Server table should have a primary key defined to ensure rows can be identified uniquely. The preferred mechanism is to define the primary key column as IDENTITY:->

1. If the primary key column has an IDENTITY specification, then the IDENTITY generator will be used to populate this column with a unique value.
2. If the primary key does not have an IDENTITY specification then :
-> For a numeric primary key Bentley Map will query for the maximum value and increment that by one when adding a new record
-> For other column types Bentley Map will attempt to store the UUID that XFM uses internally.

Regards,
Anupama Joshi

Hi Anupam , thanks for your answer

could you tell me

1. what is XFM?
2 I connect db in BGA (Bentley Geospatial Administrator) and registered featured but does not know what will i do next

(In my db i have a primary key ogr_fid)

Thanks

From the Bentley Map Help documentation in the XFM overview > The geospatial XFM (XML based Feature Modeling) engine is a facility modeling tool for defining geospatial features (roads, water mains, electric networks, and others) using a simple forms based application, Bentley Geospatial Administrator .

Bentley Geospatial Administrator is used by application designers to define all aspects of a geospatial application. These aspects are features (including symbology, properties, annotation, and placement methods), data sources associated with the application ( Bentley Geospatial Administrator and file based), topological relationships between features, domain lists, user interface elements, MicroStation workspace specific variables, source workspace folders for project specific documents such as cell libraries, macros, VBAs, and seed files.

An XFM application is comprised of a project description and corresponding source workspace files. Bentley Geospatial Administrator creates a project description stored in an XML file. The project definition must then subsequently be exported to a MicroStation workspace to make the XFM application viable.

This workspace of an XFM application consists of typical workspace files (UCF, resource files, seed files) as well as a series of XML based documents that describe the project itself. These additional XML files are read by the XFM engine and are used to configure a user's working environment.

In other words, you create your projet in Bentley Geospatial Administrator (as you did registering the features is one option of creating a project) and then export your schema using the "Export" button and then "Run" it in Bentley Map. If you added placement method to your features, you will get the command manager that will allow you to add feature instances.

If required, perhaps the Bentley Map Quick Start training class could help you to understand the workflow. But, you may need to contact your Bentley account manager regarding training options available to your company.

Regards