Data Source Parameters

VertiGIS Studio Reporting supports many different types of data sources. Each type of data source has specific configuration parameters that define how to connect it. Parameters for the following data sources are detailed below:

For more information on how to configure data sources, see Configure a Data Source.

ArcGIS Data Source Parameters

Name

The name of the data source. When added to a report, the data source name is used to identify the bound data source that appears in the Fields List. This parameter is included in the data source by default.

Type

Defines the type of data source. This parameter is set automatically. This property is included in the data source by default.

Service URL

Connection information for an ArcGIS feature or map service.

If your service is secured, the Username and Password should be defined either in the Token Username and Token Password properties or the Web Username and Web password properties.

This property is included in the data source by default.

Token Username

Defines the Username for a service secured with token-based security. To add the Token Username parameter, click Add Parameter and then select Token Username from the list of options.

ArcGIS Online-hosted feature services, services secured with federated security, or services secured with web-tier security do not require a Token Username to be defined.

Token Password

Defines the Password for a service secured with token-based security. To add the Token Password parameter, click Add Parameter and then select Token Password from the list of options.

ArcGIS Online-hosted feature services, services secured with federated security, or services secured with web-tier security do not require a Token Password to be defined.

If you ever need to change the password for an existing data source, you must type the full password. Editing selected characters in the existing password will fail.

Web Username

Defines the Username for a service secured with web-tier Security. To add the Web Username parameter, click Add Parameter and then select Web Username from the list of options.

ArcGIS Online-hosted feature services, services secured with federated security, or services secured with token-based security do not require a Token Password to be defined.

Web Password

Defines the Password for a service secured with web-tier security. To add the Web Password parameter, click Add Parameter and then select Web Password from the list of options.

ArcGIS Online-hosted feature services, services secured with federated security, or services secured with token-based security do not require a Token Password to be defined.

Other

Defines any additional parameters required for the data source. When defining the parameter name, use the name given by the provider. To add a custom parameter, click Add Parameter and then select Other from the list of options.

JSON Data Source Parameters

Name

The name of the data source. When added to a report, the data source name is used to identify the bound data source that appears in the Fields List. This parameter is included in the data source by default.

Type

Defines the type of data source. This parameter is set automatically. This property is included in the data source by default.

JSON

Defines a representative sample of the expected JSON that client applications will supply. This JSON provides the schema information the Report Designer needs to configure controls, aid in report design, and serve as sample data when you preview a report in Designer.

SQL Server Data Source Parameters

Name

The name of the data source. When added to a report, the data source name is used to identify the bound data source that appears in the Fields List. This parameter is included in the data source by default.

Type

Defines the type of data source. This property is set automatically. This parameter is included in the data source by default.

Data Source

Defines the location of the server, for example, localhost.

Data Source will always be used, as it points to the location of the SQL instance, either by common name or IP address.

This parameter is included in the data source by default.

Initial Catalog

Defines the name of the database. This parameter is included in the data source by default.

User Id

The ID of the user. This parameter is included in the data source by default.

Password

The password for the User Id. This parameter is included in the data source by default.

Server

Defines the location of the server, for example, localhost. Server is used if Data Source is not defined. To add the Server parameter, click Add Parameter and then select Server from the list of options.

Database

Defines the name of the database. Database is used if Initial Catalog is not defined. To add the Database parameter, click Add Parameter and then select Database from the list of options.

Integrated Security

Indicates if the SQL Server is secured with Windows Authentication. The allowable values include: true, false, and SSPI. Setting the value to SSPI is the preferred way to enable integrated security. To add the Integrated Security parameter, click Add Parameter and then select Integrated Security from the list of options.

Trusted Connection

Indicates if the SQL Server is secured with Windows Authentication. The allowable values include true and false. To add the Trusted Connection parameter, click Add Parameter and then select Trusted Connection from the list of options.

Other

Defines any additional parameters required for the data source. When defining the parameter name, use the name given by the provider. To add a custom parameter, click Add Parameter and then select Other from the list of options.

Other Data Source Parameters

Name

The name of the data source. When added to a report, the data source name is used to identify the bound data source that appears in the Fields List. This parameter is included in the data source by default.

Type

Defines the type of data source. This property is defined once the XpoProvider is defined. This parameter is included in the data source by default.

XpoProvider

Specifies the provider, for example, Oracle, Postgres, or MySQL. To find out the value to enter, see Connection Information for Selected Providers. This parameter is included in the data source by default.

Data Source

Defines the location of the server, for example, localhost. To add the Data Source parameter, click Add Parameter and then select Data Source from the list of options.

User Id

The ID of the user. To add the User Id parameter, click Add Parameter and then select User Id from the list of options.

Password

The password for the User Id. To add the Password parameter, click Add Parameter and then select Password from the list of options.

Server

Defines the location of the server, for example, localhost. Server is used if Data Source is not defined. To add the Server parameter, click Add Parameter and then select Server from the list of options.

Port

Defines the Port to use. To add the Port parameter, click Add Parameter and then select Port from the list of options.

Database

Defines the name of the database. Database is used if Initial Catalog is not defined. To add the Database parameter, click Add Parameter and then select Database from the list of options.

Other

Defines any additional parameters required for the data source. When defining the parameter name, use the name given by the provider. To add a custom parameter, click Add Parameter and then select Other from the list of options.