topic Re: Sort / Order Datasets in Catalog Pane in ArcGIS Pro Questions

Sort / Order Datasets in Catalog Pane

mpboyle — Mon, 10 Sep 2018 17:20:33 GMT

Is there a way to sort / order datasets in the Catalog Pane in ArcGIS Pro? We have an enterprise geodatabase that contains a lot of feature classes and tables that have a naming convention in order to make them easy to find, but for some reason in the Catalog Pane in ArcGIS Pro, datasets don't seem to always be sorted or ordered in alphabetical order.

Below is a sample screenshot of our database and the way datasets are presented.

The database and schema names are all the same, so why are datasets that starts with 'a' below those that start with 's'?

We have other datasets that start with the prefix 'asr' that are found at the top of the dataset list, why aren't these datasets grouped along with those?

FYI --- I'm using ArcGIS Pro 2.2.2

Re: Sort / Order Datasets in Catalog Pane

MichaelVolz — Mon, 10 Sep 2018 17:46:39 GMT

Are you using SQL Server as your relational database? I have Oracle and the order of data in SDE looks correct. Do you have any other relational databases to review in Pro at your org?

Re: Sort / Order Datasets in Catalog Pane

mpboyle — Mon, 10 Sep 2018 17:50:18 GMT

Yes, using SQL Server (2014 Standard). No other RDBMS to test here.

Re: Sort / Order Datasets in Catalog Pane

MichaelVolz — Mon, 10 Sep 2018 18:24:41 GMT

Do you need a SQL Server Native Client on your desktop to be able to create the sde connection in Pro? I see SQL Server Native Clients for SQL Server 2012, but none for SQL Server 2014.

Re: Sort / Order Datasets in Catalog Pane

George_Thompson — Mon, 10 Sep 2018 19:06:33 GMT

After SQL Server 2012 you need the ODBC drivers that MS provides to connect to SQL Server, not the SQL Server Native client.

Microsoft ODBC Driver for SQL Server on Windows | Microsoft Docs

Re: Sort / Order Datasets in Catalog Pane

mpboyle — Mon, 10 Sep 2018 19:23:40 GMT

Already have ODBC drivers (11 and 13) installed.