Skip to content

Command Line Tool - AnalysisContext

Introduction

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

Usage

Enlight analysisContext
        --includeDatabases=<list of databases names>
        --outputFile=<outputFile>
      | --outputFolder=<outputFolder>
        --definitionsOutputFile=<sql module definitions output file>
      --connectionString=<connectionString>
      | --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:

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

Generate analysis template using SQL Authentication:

Enlight analysisContext
        --outputFile=database-context.xml
        --server=tcp:MySqlAzure.database.windows.net,1433
        --database=MyDatabaseOnSqlAzure
        --username=testuser@mycompany.onmicrosoft.com
        --password=12345

Generate analysis template using Windows Authentication:

Enlight analysisContext
        --outputFile="c:\my database contexts\database-context.xml"
        --database=mydatabase
        --server=mysqlserver\sql01

Command Line Interface