Command Reference > Deprecated Commands > CreateReportingService (Deprecated)
  

CreateReportingService (Deprecated)

Creates a Reporting Service in the domain. Run infacmd isp EnableService to enable the Reporting Service.
The infacmd isp CreateReportingService command uses the following syntax:
CreateReportingService

<-DomainName|-dn> domain_name

<-UserName|-un> user_name

<-Password|-pd> password

[<-SecurityDomain|-sdn> security_domain]

[<-Gateway|-hp> gateway_host1:port gateway_host2:port...]

[<-ResilienceTimeout|-re> timeout_period_in_seconds]

<-ServiceName|-sn> service_name

<-NodeName|-nn> node_name

<-LicenseName|-ln> license_name

[<-FolderPath|-fp> full_folder_path]

<-ServiceOptions|-so> option_name=value ...

<-ReportingSource|-rs> option_name=value ...

[<-LineageService|-ls> option_name=value ...]
The following table describes infacmd isp CreateReportingService options and arguments:
Option
Argument
Description
-DomainName
-dn
domain_name
Required. Name of the Informatica domain. You can set the domain name with the -dn option or the environment variable INFA_DEFAULT_DOMAIN. If you set a domain name with both methods, the -dn option takes precedence.
-UserName
-un
user_name
Required if the domain uses Native or LDAP authentication. User name to connect to the domain. You can set the user name with the -un option or the environment variable INFA_DEFAULT_DOMAIN_USER. If you set a user name with both methods, the -un option takes precedence.
Optional if the domain uses Kerberos authentication. To run the command with single sign-on, do not set the user name. If you set the user name, the command runs without single sign-on.
-Password
-pd
password
Required if you specify the user name. Password for the user name. The password is case sensitive. You can set a password with the -pd option or the environment variable INFA_DEFAULT_DOMAIN_PASSWORD. If you set a password with both methods, the password set with the -pd option takes precedence.
-SecurityDomain
-sdn
security_domain
Required if the domain uses LDAP authentication. Optional if the domain uses native authentication or Kerberos authentication. Name of the security domain to which the domain user belongs. You can set a security domain with the -sdn option or the environment variable INFA_DEFAULT_SECURITY_DOMAIN. If you set a security domain name with both methods, the -sdn option takes precedence. The security domain name is case sensitive.
If the domain uses native or LDAP authentication, the default is Native. If the domain uses Kerberos authentication, the default is the LDAP security domain created during installation. The name of the security domain is the same as the user realm specified during installation.
-Gateway
-hp
gateway_host1:port gateway_host2:port
...
Required if the gateway connectivity information in the domains.infa file is out of date. The host names and port numbers for the gateway nodes in the domain.
-ResilienceTimeout
-re
timeout_period_in_seconds
Optional. Amount of time in seconds that infacmd attempts to establish or re-establish a connection to the domain. If you omit this option, infacmd uses the timeout value specified in the INFA_CLIENT_RESILIENCE_TIMEOUT environment variable. If no value is specified in the environment variable, the default of 180 seconds is used.
-ServiceName
-sn
service_name
Required. Name of the Reporting Service.
The name is not case sensitive and must be unique within the domain. The name cannot have leading or trailing spaces, include carriage returns or tabs, exceed 79 characters, or contain the following characters:
/ * ? < > " |
-NodeName
-nn
node_name
Required. Name of the node where you want the Reporting Service process to run.
-LicenseName
-ln
license_name
Required. Name of the license you want to assign to the ReportingService.
-FolderPath
-fp
full_folder_path
Optional. Full path, excluding the domain name, to the folder in which you want to create the Reporting Service. Must be in the following format:
/parent_folder/child_folder
Default is “/” (the domain).
-ServiceOptions
-so
option_name=value
Required. Service properties that define how the Reporting Service runs.
-ReportingSource
-rs
option_name=value
Required. Specify the name and type of the data source.
-LineageService
-ls
option_name=value
Optional. Lineage properties required to perform lineage analysis for data in Data Analyzer.

Reporting Service Options

Enter Reporting Service options in the following format:
infacmd CreateReportingService ... -so option_name=value option_name=value ...
To enter multiple options, separate them with a space. To enter a value that contains a space or other non-alphanumeric character, enclose the value in quotation marks.
The following table describes Reporting Service options:
Option
Description
AdditionalJdbcParams
Optional. Enter additional JDBC options. Use this option to specify character encoding or the location of a server if you are using a database server that is highly available such as Oracle RAC.
DatabaseDriver
Required. JDBC driver that the Reporting Service uses to connect to the Data Analyzer repository database.
DatabaseHost
Required. Name of the machine that hosts the database server.
DatabaseName
Required. Full service name or SID for Oracle databases. Service name for IBM DB2 databases. Database name for Microsoft SQL Server or Sybase ASE databases. Use DatabaseNameInterpretation option to specify whether the DatabaseName option contains a service name, SID, or database name.
DatabaseNameInterpretation
Required if the DatabaseName option contains a full Oracle service name. Type of DatabaseName option. You can use the following values:
  • - DatabaseName. The DatabaseName option contains a database name for Microsoft SQL Server or Sybase ASE databases, or a service name for IBM DB2 databases.
  • - OracleSID. The DatabaseName option contains an Oracle SID.
  • - OracleServiceName. The DatabaseName option contains a full Oracle service name.
By default, infacmd uses DatabaseName for all non-Oracle databases.
DatabasePassword
Required. Data Analyzer repository database password corresponding to the database user. You can set a password with the -so option or the environment variable INFA_DEFAULT_DATABASE_PASSWORD. If you set a password with both methods, the password set with the -so option takes precedence.
DatabasePort
Required. Port number for the repository database.
DatabaseTablespaceName
Required if you choose an IBM DB2 database. Tablespace name for IBM DB2 repositories. When you specify the tablespace name, the Reporting Service creates all repository tables in the same tablespace.
DatabaseUser
Required. User account for the repository database.
DatasourceDriver
Optional. The driver that the Reporting Service uses to connect to the data source.
DatasourcePassword
Required. Password corresponding to the data source user. You can set a password with the -so option or the environment variable INFA_PASSWORD. If you set a password with both methods, the password set with the -so option takes precedence.
DatasourceTestTable
Required. Test table that the Reporting Service uses to verify the connection to the data source.
DatasourceURL
Required. JDBC connection string that the Reporting Service uses to connect to the data source.
DatasourceUser
Required. User account for the data source database.
HttpPort
Required if you do not use the SslPort option. TCP port that the Reporting Service uses.
SslPort
Required if you do not use the HttpPort option. SSL port that the Reporting Service uses for secure connections.
DataSourceAdvancedMode
Edit mode that determines where you can edit Datasource properties.
When enabled, the edit mode is advanced, and the value is true. In advanced edit mode, you can edit Datasource and Dataconnector properties in the Data Analyzer instance.
When disabled, the edit mode is basic, and the value is false. In basic edit mode, you can edit Datasource properties in the Administrator tool.

Reporting Source Options

Enter Reporting source options in the following format:
infacmd CreateReportingService ... -rs option_name=value option_name=value
To enter multiple options, separate them with a space. To enter a value that contains a space or other non-alphanumeric character, enclose the value in quotation marks.
The following table describes Reporting Source options:
Option
Description
DatasourceName
Required. Name of the service for reporting.
DatasourceType
Required. Type of service. Service types include:
  • - Dataprofiling
  • - MM
  • - PCRR
  • - Other

Lineage Service Options

Enter lineage service options in the following format:
infacmd CreateReportingService ... -ls option_name=value option_name=value
To enter multiple options, separate them with a space. To enter a value that contains a space or other non-alphanumeric character, enclose the value in quotation marks.
The following table describes Lineage Service options:
Option
Description
MetadataManagerService
Optional. Name of the Metadata Manager Service to which you want to connect to perform data lineage.
ResourceName
Optional. Name of the resource in the Metadata Manager for which you loaded the Data Analyzer metadata.