MetaDataConnection (Object)

Member of:

Global object or Data Model object

Description:

Represents a Data Model metadata connection definition. Metadata connection definitions are powerful tools that you can use to link the Interactive Reporting application to metadata, or information about your database. By modifying the SQL Interactive Reporting sends to your database server, you can dictate where Interactive Reporting finds the information it uses to create a Data Model from database tables.

Metadata connection definitions read metadata from tables on the database and apply it to Data Models through a live database connection. The specifications for reading these tables are stored in the connection file. After they are configured, metadata definitions are available for anyone using the connection file.

Example:

This example creates and applies a metadata connection file (.oce) to the current document. The data source is "PlutoSQLSVR," a user DSN using the SQL Server 6.5 driver:

var myCon = Application.CreateConnection()
myCon.Description = "This OCE configures the connection via ODBC, to a SQLServer 6.5 database named pluto.
myCon.Api = bqApiOpenClient
myCon.Database = bqDatabaseSQLServer
myCon.HostName ="PlutoSQLSVR"
myCon.MetadataUsername"hyperion"
myCon.MetadataPassword = "hyperionhyperion"
myCon.MetaFileChoice = "Broadbase"
myCon.UseAlternateMetadataLocation(true,c:\\OCEs\\PlutoMeta.OCE)
myCon.EnableAsyncProcess = true
myCon.SaveAs("d:\\OCEs\\PlutoSQL.oce")

//Now use this connection in  a datamodel
ActiveDocument.Sections["Query"].DataModel.MetaDataConnection.Open()
("d:\\OCEs\\PlutoSQL.oce")

Method

Connect([optional] GetCredentials as Boolean), Disconnect(), Open(Filename As String), Save(), SaveAs(Filename As String), SetPassword(Password As String), UseAlternateMetadataLocation(Value As Boolean, [optional] MetadataOce As String)

Properties:

Read-only: Property Connected As Boolean, Property Filename As String

Read-write: Property AllowNonJoinedQueries As Boolean, Property Api As BqApi, Property AutoCommit As Boolean, Property Database As BqDatabase, Property DataBaseList As String, Property DBLibAllowChangeDatabase As Boolean, Property DBLibApiSeverity As Number, Property DBLibDatabaseCancel As BqDbLibCancelMode, Property DBLibPacketSize As Number, Property DBLibServerSeverity As Number, Property DBLibUseQuotedIdentifiers As Boolean, Property DBLibUseSQLTable As Boolean, Property EnableAsyncProcess As Boolean, Property EnableTransactionMode As Boolean, Property HostName As String, Property MetadataPassword As String, Property MetadataUser As String, Property MetaFileChoice As String, Property ODBCDatabasePrompt As Boolean, Property ODBCEnableLargeBufferMode As Boolean, Property SaveWithoutUsername As Boolean, Property ShowAdvanced As Boolean, Property ShowBrioRepositoryTables As Boolean, Property ShowMetadata As Boolean, Property SpecificMetadataLogin As Boolean, Property SQLNetRetainDateFormats As Boolean, Property StringRetrieval As Boolean, Property TimeLimit As Number, Property Username As String