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

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Bulk Data Loads from SQL into Contributor

Started by overflow, 10 Oct 2012 01:00:24 AM

Previous topic - Next topic

overflow

Hi There,

Wondering if there is an effective way of loading data from a SQL view into Contributor via the import data; I know it needs to be loaded to the im tables, but cannot find an effective set of instructions to set this up.  This is in 10.1.1.

I could create text files and have tested the view as a concept , but would like to load directly for a set of cubes from the SQL database.

Any help?

ykud

Load data into im_ tables in application database and run prepare import macro in contributor.
Import errors are logged into ie_ tables

overflow

Thanks Ykud,
What I am looking for is some instruction set on loading the data into the im- tables. Do I use a SQL query, and if so, what kind of query?

It is not readily available on any big blue site.

overflow

Just for interest sake and to note the solution:

I ended up using SQL Server Management Studio, and using the following steps:
1/Connect to the Target Database Server, and right Click on the target database (Contributor application)
2/ Select Tasks / Import Data
3/ Select Source [Database server, and then select the relevant source database (in this case a publish view from the old 7.3 environment)
4/ Select Copy data from more than one table or view
5/ Select the Source Tables to copy (in this case ev_tablename)
6/ Identify the appropriate Target tables to copy to (in this case - and typically always - im_tablename)
7/ Edit mappings, and select the Destination for exportvalue as importvalue.
8/ Repeat steps 5 - 7 for all tables to be copied.
9/ Select Next / Next (run). 
This copies the tables selected to the im_tables in the target Contributor database.  From there it follows standard documentary process:
10/ Prepare the cubes for which data is imported; in this case I zeroed them also
11/ GTP the application.