Ironside Group
  • Home
  • About
  • Ascent Solutions
  • Capabilities
  • Info & Events
  • Blog
  • Careers
  • Contact
  • Search
  • Menu Menu
Request a Meeting
Business Analytics, Technology Spotlight

Ironside Tech Tip: Connect to Different Data Sources by User or Group Association

data sources bundled cables concept
April 20, 2016/by Ironside Group

Metadata packages usually connect or point to particular data sources, but what if for testing, business, or application reasons you need a package to dynamically reference a different data source based on the executing user, user job function, or user location?

For example, we had a client that supported four separate hospitals using an IBM Cognos BI platform. All of the hospitals used identical reports and package designs; however the data was unique for each location and was physically stored in different locations.  The metadata modeler needed an easy way to automatically point to each of the different data sources for users in each location without creating (and maintaining)  four separate packages that only differed in their data source connections. Ironside was able to show them how to accomplish this in four steps.

Changing Data Sources Overview

  1. Create the data source in Cognos Administration for each of the user locations (e.g Hospital_1, Hospital_2, etc.).
  2. Add a user group in LDAP that associates Cognos users with a particular data source.
  3. Create a parameter map to associate the user with their appropriate data source and point to it.
  4. Use a macro in each of the data sources’ definitions to use the elements created in steps 1 and 2 to substitute in the data source that meets each user’s criteria.

Detailed Procedure

The four steps above are the goals behind each of the more in-depth tasks shown below. I’ve broken up the workflows based on which of the overview steps they correspond to.

Step 1: Check Data Source Availability

The different data sources you plan to use must be available in Cognos Connection.

Data Sources Availability Example

If one of the data sources you need isn’t available, you will need to add it by setting up a connection to it in Cognos Administration.

Step 2: Add Location Information to LDAP

Your environment’s LDAP administrator needs to add a field into each user or group’s security profile that assigns a location to those users and groups that corresponds with the syntax used for your data sources.

LDAP Settings Example

Identifying the locations this way in the security profiles ensures that the user’s information will match the data source they need to access.

Step 3: Build the Parameter Map

To build a parameter map in Framework Manager, you first click Parameter Maps > Create > Parameter Map to bring up the parameter map wizard window and name your parameter map.

Parameter Map Naming Example

You then define the keys and values in your parameter map so that they correlate with what you entered in LDAP for your users and groups. When all definitions are in place, click Finish to generate the parameter map.

Parameter Map Keys and Values Example

Step 4: Build Macros into Your Data Sources

You edit the definitions of your data sources from a Framework Manager project by expanding the Content Manager Data Source field in the project’s Properties pane.

FM Project Properties Example

To make it so this property looks to your parameter map to get its data source definition, delete any current information in the window, click the Insert Macro button, and add a macro definition like the one below that contains the names of the parameter map and session parameters you want to use.

Macro Definition Example

The Result: Automatically Interchangeable Data Sources

When users from the different locations you defined log on, they will trigger the macro you created, which will reference the parameter map to point each user at the data source that matches their credentials.

Security and configuration topics are key components of all Ironside’s instructor-led classes.  To learn more about how we can help you become a BI expert and apply these and other innovative techniques, please see our upcoming class schedule.

Additional Note: This technique will also work for individual users as well.  To set it up this way, create a parameter map listing the user logon names correlating to each data source, then inside the macro (see Step #4) use the session parameter $account.personalInfo.userName

Tags: Business Analytics Education, Business Analytics Training, Business Intelligence, IBM Cognos Business Intelligence, Metadata, Security, Tech Tip
https://www.ironsidegroup.com/wp-content/uploads/2016/04/Bundled-Cables-Resized.jpg 350 750 Ironside Group https://www.ironsidegroup.com/wp-content/uploads/2018/03/logo-with-words.png Ironside Group2016-04-20 18:28:312019-01-22 11:33:29Ironside Tech Tip: Connect to Different Data Sources by User or Group Association

See 3 reasons why AWS analytics are well within your reach.

Recent Posts

  • Why outsourcing can make all the difference when it comes to successful data and analytics transformation
  • What’s keeping mid-market companies from leveraging advanced analytics and AI in 2023?
  • Learn Why So Many Companies Are Turning to
    a Hub-and-Spoke Data Model
  • Data governance presents big challenges in the mid-market
  • Mid-market Leaders Report Back from the Road

Categories

  • Awards & Recognition
  • Business Analytics
  • Data Management
  • Data Science
  • Featured
  • Technology Spotlight
  • Uncategorized

Newsletter

Ironside Follow

We make the world of business smarter. A trusted partner who turns data into valuable insights that drive positive business outcomes #Data #Analytics #AI #Cloud

IronsideGroup
Retweet on Twitter Ironside Retweeted

▶️ WATCH | Panelists at the CDO Midwest Summit 2022, share insights on accelerating innovation and using data and analytics as business drivers.
https://bit.ly/3IV0Vxm

@Rackspace
@BelcanGlobal
@SVB_UK
@MedOneInc
@IronsideGroup

✔️Check out our 2023 events here:

Reply on Twitter 1633195811294298112 Retweet on Twitter 1633195811294298112 1 Like on Twitter 1633195811294298112 Twitter 1633195811294298112

For today's #Take30 #TBT, we're revisiting our S.A.L.T. demo, exploring the powerful combination of #Snowflake, #Alteryx, & #Tableau and how it can be used to implement a #ModernAnalyticsFramework. Check it out here: https://irns.de/3leq2Dv

Reply on Twitter 1636480297045819396 Retweet on Twitter 1636480297045819396 Like on Twitter 1636480297045819396 Twitter 1636480297045819396

For today's #Take30 #tbt, we revisit our session on how the #Banking industry can utilize #advancedanalytics to help their business. Check out this clip to see the use cases our expert cover, and click the link for the full session! #DataScience https://irns.de/3L82JFS

Reply on Twitter 1633968390128664588 Retweet on Twitter 1633968390128664588 Like on Twitter 1633968390128664588 Twitter 1633968390128664588

We are happy to announce a new member of our #DataScience practice, Josh Angelchik. Bringing his experience from both the #consulting and #product sides at companies of all sizes, Josh can optimize existing data workflows and bring product ideas to life from scratch.

Reply on Twitter 1626644704887509005 Retweet on Twitter 1626644704887509005 Like on Twitter 1626644704887509005 Twitter 1626644704887509005

Are you trying to implement #ArtificialIntelligence in your organization? Ironside EVP Paul Hardy breaks down the benefits of AscentAI, our #DSaaS offering that adds #DataScience into your business at a fraction of the cost. Watch the full webinar here: https://irns.de/3KeGHkj

Reply on Twitter 1626339542943801351 Retweet on Twitter 1626339542943801351 Like on Twitter 1626339542943801351 Twitter 1626339542943801351

Ironside helps companies translate business goals and challenges into technology solutions that enable insightful analysis, data-driven decision making and continued success. We help you structure, integrate and augment your data, while transforming your analytic environment and improving governance.

LINKS

  • Home
  • About
  • Ascent Solutions
  • Capabilities
  • Info & Events
  • Blog
  • Careers
  • Contact

GET IN TOUCH

781-860-8840

GetInsights@IronsideGroup.com

Corporate Mailing Address
177 Huntington Ave Ste. 1703
PMB 89714
Boston, Massachusetts 02115-3153

131 Hartwell Ave
Lexington, MA 02421

Regional offices in Boston, New York City, Philadelphia, Austin, and Cincinnati

>>Managed Services Support

  • linkedin
  • twitter
  • youtube
  • mail
Also of Interest
  • Amazon Archives
  • QuickSight Archives
  • Top New Features in Tableau 10
© 1999-2022 Ironside Group. All Rights Reserved.
Ironside Webinar Series: IT-Driven vs. User-Driven Analytics: How to Coexis...IT-driven vs user-driven analytics concept tug of warvintage police carIntroducing Matt Barter, Industry Lead, Crime Prediction & Prevention
Scroll to top
Send this to a friend