Command Line Tool – AnalysisContext

Generate and output the context information of given database to a file.

This topic contains the following sections:

Usage
Copy
1Enlight analysisContext
2        --includeDatabases=<list of databases names>
3        --outputFile=<outputFile>
4      | --outputFolder=<outputFolder>
5        --definitionsOutputFile=<sql module definitions output file>
6            --connectionString=<connectionString> 
7      | --server=<servername> --database:<databaseName> [ --username:<username>  --password:<password> ]]

Parameters

Parameter

Description

includeDatabases

Comma separated list of database names for which to include metadata in the analysis context XML file.

outputFile

Required. Output file for the generated analysis context XML file.

definitionsOutputFile

Output file for the sql module definitions XML file.

connectionString

SQL connection string the target context database.

username

Username for accessing the database using SQL Server authentication.

password

The password of the provided user for accessing the database using SQL Server authentication.

database

“SQL connection target database name.

server

“SQL connection target server name and instance name.
Examples

Generate analysis template using SQL Connection string:

Copy
1Enlight analysisContext 
2        --connectionString=Server=tcp:MySqlAzure.database.windows.net,1433;Database=MySqlAzureDatabase;UID=testuser@mycompany.onmicrosoft.com;PWD=12345; 
3        --outputFile=database-context.xml

Generate analysis template using SQL Authentication:

Copy
1Enlight analysisContext 
2        --outputFile=database-context.xml 
3        --server=tcp:MySqlAzure.database.windows.net,1433 
4        --database=MyDatabaseOnSqlAzure 
5        --username=testuser@mycompany.onmicrosoft.com
6        --password=12345

Generate analysis template using Windows Authentication:

Copy
1Enlight analysisContext                                  
2        --outputFile="c:my database contextsdatabase-context.xml"  
3        --database=mydatabase 
4        --server=mysqlserversql01

See Also

Other Resources

Command Line Interface