If you are unable to create a new account, please email bspsoftware@techdata.com

Author Topic: bcp utility in metric studio  (Read 8370 times)

rajwarrier

  • Guest
bcp utility in metric studio
« on: 10 Feb 2011 11:35:46 am »
We have metric server component installed correctly in our distributed cognos 8.4 installation.
the doubt we have is
  Do we need bcp-utility on any of the app server boxes or content machine box or the webserver box ?
If a user installs metric designer tool on his machine, will he need the sql bcp utility on his machine ?
How does bcp play a role in Metric studio/designer ??
thank you all !

RobsWalker68

  • Guest
Re: bcp utility in metric studio
« Reply #1 on: 10 Feb 2011 12:23:41 pm »
Hi,

Metric designer doesn't need a bcp utility as it acts upon existing Cognos data sources i.e framework packages, cubes etc. You can then either execute the job on Metric Designer to transfer the data to the staging tables in the Metric Store or more commontly create a job on the Cognos server that can be scheduled.

As you mention using a bcp utility do you therefore need to  load data from a non cognos source(s)?

Rgds

Rob