Import Data using SQL Tables

[Former Member]

Hi,

Im trying to import data from my SAP ERP, I succesfully did it using an ETL -> flat files.

Another test is to perform the import by using SQL Tables.

- Is this feasible by replacing the table containing the data (fact, fac2, wb) ?

- Once BPC -SQL is installed, everytime I create a new Appset, a DB is created in SQL... in my opinion, this may be created with particular characteristics, features, etc... therefore are there any properties or some "particular info" that can be missed by replacing the table ?

- If I do not replace the table but send data from my ERP SQL table to the BPC SQL table, am I taking a risk by trying to match tables?

If there is a chance to do it, can you please provide some advice / info for this procedure...

Thanx in advance

Velázquez

[Former Member]

I am pretty certain that if you have an ERP system, and write values in the form of FACT records to a SQL table, that you may then run the BPC DUMP/LOAD TASK off the SQL table that was populated, which will then update the values in the existing FAC2 or WB tables. I would not try to update or replace the value in the 3 tables.

Hope this helps.

[Former Member]

Hi Petar,

Thanx for the response, its really helpful. I am just wondering where do I find this DUMP-LOAD Task... By the name Task I automatically think about permissions in the Administrator.... I also looked for a package named this way but didnt find it.

What do you mean exactly by the "run the BPC DUMP/LOAD TASK", where do I find it ?

Thanx again, regards.

Velázquez

[Former Member]

Hi,

This is a BPC task. You need to go to SQL Business Intelligence Studio (installed on the server). There will be lot of tasks available in there. You will find the BPC tasks there.

Hope this helps.

[Former Member]

Hi Nilanjan,

I need help ASAP.

About this dump-load task, how does it works? Because I was checking out a package called Import SQL and this one only imports data from a table, however this table has to be allocated within the database that is being used, and I right? Are these 2 related somehow?

Does this task order BPC to find data from a SQL Table (allocated in a different server, different instance for SQL) and import it to SQL Fac2 table?

Can you help me with a simple explanation what do I need to do to run this task? The page help.sap.com talks shows a section within DumpLoad Task Usage which is called Importing Into SQL Server...

* Processing the Application using DumpLoad -

Importing into SQL

You can use DumpLoad to process the application as a standalone procedure, or with data import, export, or clear.

Prerequisites

The DumpLoad task (OsoftTaskDumpLoad2008.dll) is registered with Microsoft SSIS. See Registering Custom Tasks.

Procedure

1.Open a package or create a new package in Microsoft SSIS on the Planning and Consolidation server. i already did this for the DumpLoad task ... should I do this for the Import SQL task also ?

2.Select the task and add it to the package. WHAT DOES SELECT THE TASK MEAN?

3.Open the task, and choose Data Management None .

4.Enter the application set, application, and user ID.

Im getting confused, can you please provide more details about the whole procedure. Thanx in advance

Velázquez