Search for	Example	Results
A single word	`cat`	Topics that contain the word "cat". You will also find its grammatical variations, such as "cats".
A phrase. You can specify that the search results contain a specific phrase.	`"cat food"` (quotation marks)	Topics that contain the literal phrase "cat food" and all its grammatical variations. Without the quotation marks, the query is equivalent to specifying an OR operator, which finds topics with one of the individual words instead of the phrase.

Search for	Operator	Example
Two or more words in the same topic	`AND` `and` `+` (plus symbol) `&` (ampersand)	`cat AND dog` `"cat food"+milk` `"cat food"&"dog food"`
Either word in a topic	`OR` `or` `\|` (pipe)	`cat OR dog` `cat \| dog`
Topics that do not contain a specific word or phrase	`NOT` `not` `!` (exclamation point)	`NOT cat` `! dog`
Topics that contain one string and do not contain another	`^` (caret)	`cat ^ mouse`
A combination of search types	`( )` parentheses	`cat + (dog \| mouse)` `cat \| dog + (! mouse)`

IT Business Analytics10.10

Develop > Develop Content > Extend Content > Content Development Process > Activate the CP and Run the ETL > Activate a New CP

Activate a new CP

After you package and deploy new Content Packs, you activate the content in the ITBA Connect Data Source UI. The content is created from databases (MSSQL ,ORACLE and MYSQL) according to your specific Content Pack source.

To access:

Activate a new Content Pack

CP Activation Page Options

Activation parameters are based on the Data Source Type of your Content Pack.

MSSQL Database Source CP

UI Element	Description
Instance name	Enter a name for the data source instance you are activating.
<CP name> Version	1
Time Zone	Select the time zone for the data source.
Data Source Type	Select MSSQL.
Username	Enter your username used to log on to the database.
Password	Enter your password used to log on to the database.
Hostname/IP Address	Enter the SQL server database hostname or IP address.
Port	Enter the server port number.
Database Name	Enter the database name used by the CP.
Initial Load Period (months)	Select the number of months from which you want the initial data loaded.

MySQL Database Source CP

UI Element	Description
Instance name	Enter a name for the data source instance you are activating.
<CP name> Version	1
Time Zone	Select the time zone for the data source.
Data Source Type	Select MySQL.
Username	Enter your username used to log on to the database.
Password	Enter your password used to log on to the database.
Hostname/IP Address	Enter the MySQL server hostname or IP address.
Port	Port for database connections.
Initial Database Name Load Period (months)	Select the number of months from which you want the initial data loaded.

Oracle Database Source CP

Note The Oracle database can have both Server ID (SID) and Service Name properties, but the user should specify only one. If you define the SID, then the SID is used, and if you define Service Name, then Service Name is used. If you define both in the UI, only SID is used.

UI Element	Description
Instance name	Enter a name for the data source instance you are activating.
<CP name> Version	1
Time Zone	Select the time zone for the data source.
Data Source Type	Select Oracle.
Username	Enter your username used to log on to the database.
Password	Enter your password used to log on to the database.
Hostname/IP Address	Enter the Oracle server hostname or IP address.
SID	Enter the unique name of the database.
Service Name	Enter the alias used when connecting.
Initial Load Period (months)	Select the number of months from which you want the initial data loaded.

.TXT File Source CP

UI Element	Description
Instance name	Enter a name for the data source instance you are activating.
<CP name> Version	1
Time Zone	Select the time zone for the data source.
Data Source Type	Select Delimited File.
directory Path	Enter the path where the data source file is located.
Encoding	Enter the text encoding of the file. The default is UTF-8.
Field Delimiter	Enter the field delimiter for the file, such as ','.
Row Delimiter	Enter the row delimiter for the file, such as '\r\n'.
Initial Load Period (months)	Select the number of months from which you want the initial data loaded.

Excel File Source CP

UI Element	Description
Instance name	Enter a name for the data source instance you are activating.
<CP name> Version	1
Time Zone	Enter the time zone for the data source.
Data Source Type	Select Excel File.
directory Path	Enter the path to excel data source file.
Initial Load Period (months)	Select the number of months from which you want the initial data loaded.

Send Help Center feedback