IAdoMdCatalog.WellKnownDriver

Syntax

WellKnownDriver: AdoMdWellKnownDriverType;

Description

The WellKnownDriver property determines the driver used on opening the ADOMD catalog.

Comments

If the WellKnownDriver property is set to AdoMdWellKnownDriverType.None, value of the Driver property must be defined.

Example

Sub UserProc;
Var
    MB: IMetabase;
    CrInfo: IMetabaseObjectCreateInfo;
    CatAdo: IAdoMdCatalog;
Begin
    MB := MetabaseClass.Active;
    CrInfo := MB.CreateCreateInfo;
    CrInfo.ClassID := MetabaseObjectClass.KE_CLASS_ADOMD_CATALOG;
    CrInfo.Id := "SAP_TEST";
    CrInfo.Name := "Catalog based on SAP NetWeaver BW;
    CrInfo.Parent := MB.Root;
    CatAdo := MB.CreateObject(CrInfo).Edit As IAdoMdCatalog;
    CatAdo.WellKnownDriver := AdoMdWellKnownDriverType.SAP;
    CatAdo.Server := "Sap_test";
    CatAdo.Name := "$TEST_CUBE";
    CatAdo.ProviderString := "SFC_CLIENT=001";
    CatAdo.LoginPrompt := True;
    (CatAdo As IMetabaseObject).Save;
End Sub UserProc;

After executing the example a new ADOMD catalog is created in the repository root directory. This catalog is set up to connect to the $TEST_CUBE database located on the Sap_test server. SAP NetWeaver BW driver is used at connection. "001" is the client used to perform the connection. Credentials dialog box is displayed on opening the catalog.