Planning Analytics

Planning Analytics

Get AI-infused integrated business planning

 View Only

TM1 Perspectives VBA migration from native to CAM authentication

  • 1.  TM1 Perspectives VBA migration from native to CAM authentication

    Posted 20 hours ago

    Hello Community

     

    I am reaching out to the IBM community for assistance with a migration task that I am currently working on.

    I have been using Excel VBA with TM1 Perspective connected to TM1 through native authentication (IntegratedSecurityMode=1) for many years.

    Now, I need to migrate this setup to use CAM authentication with AD SSO.

     

    To facilitate this migration, I am using the n_connect_cam_bridge.dll in addition to tm1api.dll to enable VBA to connect to TM1 using CAM.

    I have been following the sample provided by IBM, which utilizes the n_connect_cam_bridge.dll based on the documentation found here: https://www.ibm.com/support/pages/tm1-api-excel-vba-coding-and-library-automatically-connect-tm1-server-ibm-cognos-cam-security-mode-4-and-5.

     

    However, I am encountering some challenges and would greatly appreciate any best practices or additional samples that could help guide me through this process.

    Any insights or experiences you could share would be invaluable.

     

    Thank you for your time and assistance.

     

    Best regards,

    Gabi Cohen

    Deloitte refers to a Deloitte member firm, one of its related entities, or Deloitte Touche Tohmatsu Limited ("DTTL"). Each Deloitte member firm is a separate legal entity and a member of DTTL. DTTL does not provide services to clients. Please see www.deloitte.com/about to learn more.