Main menu

Pages

Edit post

Clear and Create Workspace, Create Cloud Storage Connection File and Database Connection

Husam Jubeh
(0)

Clear and Create  Workspace, Create Cloud Storage Connection File and Database Connection Tools

Clear Workspace Cache

How to Clear Workspace Cache Tool in Arc Toolbox ArcMap ArcGIS??

Clear Workspace Cache Tool
Clear Workspace Cache

Path to access the tool

:

Clear Workspace Cache Tool, Workspace Toolset, Data Management Tools Toolbox

 

Clear Workspace Cache

Clears any enterprise geodatabase workspaces from the enterprise geodatabase workspace cache.

1.    Input Workspace (optional)

The enterprise geodatabase database connection file representing the enterprise geodatabase workspace to be removed from the cache. Specify the path to the enterprise geodatabase connection file that was used in running your geoprocessing tools in order to remove the specific enterprise geodatabase workspace from the cache. Passing no input parameter will clear all enterprise geodatabase workspaces from the cache.

Create ArcInfo Workspace

How to Create ArcInfo Workspace Tool in Arc Toolbox ArcMap ArcGIS??

Create ArcInfo Workspace Tool
Create ArcInfo Workspace

Path to access the tool

:

Create ArcInfo Workspace Tool, Workspace Toolset, Data Management Tools Toolbox

 

Create ArcInfo Workspace

Creates a workspace with an INFO subdirectory.

1.    ArcInfo Workspace Location

Location where the ArcInfo workspace will be created.

2.    ArcInfo Workspace Name

Name of the ArcInfo workspace to be created.

Create Cloud Storage Connection File

How to Create Cloud Storage Connection File Tool in Arc Toolbox ArcMap ArcGIS??

Create Cloud Storage Connection File Tool
Create Cloud Storage Connection File

Path to access the tool

:

Create Cloud Storage Connection File Tool, Workspace Toolset, Data Management Tools Toolbox

 

Create Cloud Storage Connection File

Creates a connection file for ArcGIS-supported cloud storage. It allows existing raster geoprocessing tools to write cloud raster format (CRF) datasets into the cloud storage bucket or read raster datasets (not limited to CRF) stored in the cloud storage as input.

1.    Connection File Location

The folder path where the connection file will be created.

2.    Connection File Name

The name of the cloud storage connection file.

3.    Service Provider

Specifies the cloud storage service provider.

  1. AZURE—Microsoft Azure
  2. AMAZON—Amazon S3
  3. GOOGLE—Google Cloud Storage
  4. ALIBABA—Alibaba Cloud Storage
  5. WEBHDFS—WebHDFS

4.    Access Key ID (Account Name) (optional)

The access key ID string for the specific cloud storage type. It can also be the account name as is the case with Azure.

5.    Secret Access Key (Account Key) (optional)

The secret access key string to authenticate the connection to cloud storage.

6.    Bucket (Container) Name

The name of the cloud storage container where the raster dataset will be stored. For many cloud providers, it is also called a bucket.

7.    Folder (optional)

Specify a folder in the cloud storage Bucket (Container) Name where the raster dataset will be stored.

8.    Region (Environment) (optional)

The region string for the cloud storage. If provided, the value must use the format defined by the cloud storage choice. The default is the selected cloud provider's account default.

9.    Service End Point (optional)

The service endpoint (uris) of the cloud storage, such as oss-us-west-1.aliyuncs.com. If the parameter is not provided, the default endpoint for the selected cloud storage type will be used. The CNAME redirected endpoint can be used if needed.

10. Provider Options (optional)

Specifies configuration options pertaining to the specific type of cloud service. Some services offer options, some do not. You only need to set the option if you want to turn them on. Provider Options (optional)

Create Database Connection

How to Create Database Connection Tool in Arc Toolbox ArcMap ArcGIS??

Create Database Connection Tool
Create Database Connection

Path to access the tool

:

Create Database Connection Tool, Workspace Toolset, Data Management Tools Toolbox

 

Create Database Connection

Creates a file that ArcGIS uses to connect to a database or an enterprise, a workgroup, or a desktop geodatabase.

1.    Connection File Location

The folder path where the database connection file (.sde file) will be stored.

2.    Connection File Name

The name of the database connection file. The output file will have the extension .sde.

3.    Database Platform

Specifies the database management system platform to which you will be connecting. The following are valid options:

  1. Dameng—The name of the server where the Dameng database is installed
  2. DB2—The name of the cataloged Db2 database
  3. DB2 for Z/OS—The name of the cataloged Db2 database
  4. Informix—The Open Database Connectivity (ODBC) data source name for the Informix database
  5. Oracle—Either the TNS name or the Oracle Easy Connection string to connect to the Oracle database
  6. PostgreSQL—The name of the server where PostgreSQL is installed or the name of the PostgreSQL database service instance
  7. SAP HANA—The ODBC data source name for the SAP HANA database
  8. SQL Server—The name of the SQL Server or SQL Database instance
  9. Teradata—The ODBC data source name for the Teradata database

4.    Instance

The database server or instance to which you will connect.

The value you choose from the Database Platform drop-down list indicates the type of database to which you want to connect. The information you provide for the Instance parameter varies, depending on the connection type you choose.

See below for further information on what to provide for each database platform.

  1. Dameng—The name of the server where the Dameng database is installed
  2. DB2—The name of the cataloged Db2 database
  3. DB2 for Z/OS—The name of the cataloged Db2 database
  4. Informix—The Open Database Connectivity (ODBC) data source name for the Informix database
  5. Oracle—Either the TNS name or the Oracle Easy Connection string to connect to the Oracle database
  6. PostgreSQL—The name of the server where PostgreSQL is installed or the name of the PostgreSQL database service instance
  7. SAP HANA—The ODBC data source name for the SAP HANA database
  8. SQL Server—The name of the SQL Server or SQL Database instance
  9. Teradata—The ODBC data source name for the Teradata database

5.    Database Authentication (optional)

Specifies the type of authentication that will be used.

  1. Checked—Database authentication will be used. An internal database user name and a password are used to connect to the database. You aren't required to type your user name and password to create a connection; however, if you don't, you will be prompted to enter them when a connection is established.
  2. Unchecked—Operating system authentication will be used. You do not need to type a user name and password. The connection will be made with the user name and password that were used to log in to the operating system. If the login used for the operating system is not a valid geodatabase login, the connection will fail.

6.    Username (optional)

The database user name that will be used when using database authentication.

7.    Password (optional)

The database user password that will be used when using database authentication.

8.    Save username and password (optional)

Specifies whether the user name and password will be saved.

  1. Checked—The user name and password will be saved in the connection file. This is the default. If the connection file you are creating will provide ArcGIS services with access to the database or geodatabase, or if you want to use the Catalog search to locate data accessed through this connection file, you must save the user name and password.
  2. Unchecked—The user name and password will not be saved in the file. Every time you attempt to connect using the file, you will be prompted for the user name and password.

9.    Database (optional)

The name of the database to which you will connect. This parameter only applies to PostgreSQL and SQL Server platforms.

10. Schema (Oracle user schema geodatabases only) (optional)

The user schema geodatabase to which you will connect. The tool will determine if it is connecting to an Oracle database that contains a user–schema geodatabase. If the Oracle database contains a user schema, this option is active; otherwise, it remains inactive. The default option for this parameter is to use the sde schema (master) geodatabase.

11. Version Type (optional)

Specifies the type of version to which you will connect. This parameter only applies when connecting to a geodatabase.

  1. TRANSACTIONAL—Connect to a transactional version. If Transactional is selected, the The following version will be used parameter will be populated with a list of transactional versions, and the Date and Time parameter will be inactive. This is the default.
  2. HISTORICAL—Connect to an historical marker. If Historical is selected, the The following version will be used parameter will be populated with a list of historical markers, and the Date and Time parameter will be inactive.
  3. POINT_IN_TIME—Connect to a specific point in time. If Point in time is selected, the The following version will be used parameter will be inactive, and the Date and Time parameter will become active.

If HISTORICAL is selected and a name is not provided in the version parameter, the default transactional version will be used. If POINT_IN_TIME is selected and a date is not provided in the date parameter, the default transactional version is used.

12. The following version will be used (optional)

The geodatabase transactional version or historical marker to connect to. The default option uses the default transactional version.

13. Date and Time (optional)

The value representing the date and time that will be used to connect to the database. This option is used with archive-enabled data. Use the time picker to choose the appropriate date.

  • If manually entering a date, the following formats can be used:
  • 6/9/2011 4:20:15 PM
  • 6/9/2011 16:20:15
  • 6/9/2011
  • 4:20:15 PM
  • 16:20:15
  • If a time is entered without a date, the default date of December 30, 1899, is used.
  • If a date is entered without a time, the default time of 12:00:00 AM will be used.

Latest articles from : Data Management

Comments

Post a Comment

table of contents title