Way to integrate CMDB like Customer user backend: DB

[naimson]

Hello. We want to integrate CMDB with our system ( all dates in tables) . In Customer we have done this by this way

Code: Select all

# 1. Customer user backend: DB
# (customer database backend and settings)
    $Self->{CustomerUser} = {
    Name => 'Customer Database',
    Module => 'Kernel::System::CustomerUser::DB',
    Params => {
        DSN => "DBI:Oracle:host=$Self->{DatabaseHost};sid=IRONLEG;port=1521",
        User => 'otrs',
        Password => '*****',
        Table => 'ironleg.otrs_customers_v',
    },
    # customer unique id
    CustomerKey => "school_id",
    # customer #
    CustomerID => 'school_name',
    CustomerValid => 'school_id',
    CustomerUserListFields => ['school_name', 'school_id','city_name','phone', 'email'],
    CustomerUserSearchFields => ['school_name','school_id','city_name','phone'],
    CustomerUserSearchPrefix => '',
    CustomerUserSearchSuffix => '*',
    CustomerUserSearchListLimit => 25,
    CustomerUserPostMasterSearchFields => ['email'],
    CustomerUserNameFields => ['school_name','school_id', 'city_name','phone', 'email'],
    CustomerUserEmailUniqCheck => 0,
#    # show not own tickets in customer panel, CompanyTickets
#    CustomerUserExcludePrimaryCustomerID => 0,
#    # generate auto logins
    AutoLoginCreation => 1,
    AutoLoginCreationPrefix => 'auto',
#    # admin can change customer preferences
  #    AdminSetPreferences => 1,
#    # cache time to live in sec. - cache any database queries
    CacheTTL => 0,
#    # just a read only source
    ReadOnly => 0,
    Map => [
        # note: Login, Email and CustomerID needed!
        # var, frontend, storage, shown (1=always,2=lite), required, storage-type, http-link, readonly, http-link-target
        [ 'UserLogin',      'Username',   'school_name',        1, 1, 'var', '', 0 ],
        [ 'UserEmail',      'Email',      'email',      1, 0, 'var', '', 0 ],
        [ 'UserCustomerID', 'CustomerID', 'school_id', 0, 1, 'var', '', 0 ],

So it there some way to do this ?

[reneeb]

No... What do you want to achieve by integrating the CMDB?