IAdoMdCatalog.WellKnownDriver

Fore Syntax

WellKnownDriver: AdoMdWellKnownDriverType;

Fore.NET Syntax

WellKnownDriver: Prognoz.Platform.Interop.AdoMd.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.

Fore 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.

Fore.NET Example

This example is an entry point of the .NET assembly.

Imports Prognoz.Platform.Interop.AdoMd;
Imports Prognoz.Platform.Interop.Metabase;

Public Shared Sub Main(Params: StartParams);
Var
    MB: IMetabase;
    CrInfo: IMetabaseObjectCreateInfo;
    CatAdo: IAdoMdCatalog;
Begin
    MB := Params.Metabase;
    CrInfo := MB.CreateCreateInfo();
    CrInfo.ClassID := Convert.ToInt32(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.adomdwkdtSAP;
    CatAdo.Server := "Sap_test";
    CatAdo.Name := "$TEST_CUBE";
    CatAdo.ProviderString := "SFC_CLIENT=001";
    CatAdo.LoginPrompt := True;
    (CatAdo As IMetabaseObject).Save();
End Sub;

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 BW driver is used at connection. "001" is the client used for connection. Credentials dialog box is displayed on opening the catalog.