Meta Integration® Model Bridge (MIMB)
"Metadata Integration" Solution
MIMB Bridge Documentation
MIMB Import Bridge from Microsoft SQL Server Analysis Services 2005 to 2008 (File)
| Microsoft |
| SQL Server Analysis Services (SSAS) |
| 9.0 (2005) to 10.0 (2008) |
| http://msdn2.microsoft.com/en-us/library/ms175609.aspx |
| [Business Intelligence] BI Design (RDBMS Source, OLAP Source, Dimensional Target, Transformation Lineage, Expression Parsing) via XMLA XML File |
Import tool: Microsoft SQL Server Analysis Services (SSAS) 9.0 (2005) to 10.0 (2008) (http://msdn2.microsoft.com/en-us/library/ms175609.aspx)
Import interface: [Business Intelligence] BI Design (RDBMS Source, OLAP Source, Dimensional Target, Transformation Lineage, Expression Parsing) via XMLA XML File from Import bridge: 'MicrosoftSqlServerXMLA' 6.1.0 - Mar 2 2010 19:13:14
The Metadata for the Microsoft SQL Server Analysis Services is managed by two tools, each of which produces a single XML file, with extension 'xmla' or 'asdatabase' respectively.
A) SQL Server Business Intelligence Development Studio: The tool generates a file with extension 'asdatabase', when the project is built. Please find the file in the project's bin directory, for example: 'C:\Visual Studio 2005\Projects\Test\bin\Test.asdatabase'
B) SQL Server Management Studio: The tool is used to connect to an existing Analysis Services server. One can export a single xmla file from the tool by choosing the database and using the command: 'Script Database as->CREATE To -> File...'.
| File |
The bridge imports an XML file with XMLA or asdatabase extension. |
FILE |
|
|
Mandatory |
| __Incremental harvesting date |
If a date is set, only metadata created or updated since the date will be imported. Use the ISO 8601 date format: yyyy-MM-dd HH:mm:ss |
DATE |
|
|
Hidden |
