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, 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, |
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: |
Trusted Connection |
Indicates if the SQL Server is secured with Windows Authentication. The allowable values include |
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, |
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, |
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. |