How to create manually data sources?

Pre-requisite

You need a configured source system. Read How to connect Galaxy to BI? to learn how to create a source system.

Create an Application Component

Open first the data sources tree for your source system. Start first the transactionRSA1, select Source Systems in the left menu and double click on your source system. You can also select directly DataSources in the left menu and then filter the datasources for your source system (use the Choose Source System button in the toolbar of the data source list panel).

Then right click on DataSources for … table header and select Create Application Component.

/wp-content/uploads/2015/01/fig_1_621315.jpg

/wp-content/uploads/2015/01/fig_2_621316.jpg

  1. Enter the name of the new application component. This name should be unique.
  2. Enter the description. Notice that the description is used as display name.
  3. Press the Continue button.

Create a Data Source

Select first the application component you created, and open the context menu with a right click. Select the menu item Create DataSource.

/wp-content/uploads/2015/01/fig_3_621317.jpg


/wp-content/uploads/2015/01/fig_4_621318.jpg

  1. Enter the name of your data source.
  2. Select Transaction Data in the drop-down list.
  3. Press the Continue button.

The data source will be created and opened.


/wp-content/uploads/2015/01/fig_5_621319.jpg

  1. Select the Extraction tab.
  2. Click on selection button. A pop-up will list all the available source objects. Select the desired one.

Now the source object has been selected, the data source fields have to be defined and mapped to the ones of the source object.


/wp-content/uploads/2015/01/fig_6_621320.jpg

  1. Select the Proposal tab.
  2. Press the Default System Proposal button. It will select all the fields listed in the table below.
  3. Makes sure that at least one field has been selected. Normally, all of them should be selected. If you do not want some fields, uncheck them.

Press finally the Activate button in the toolbar. The data source will be finalized and activated (a data source can only be used after being activated).

The message Field list no longer corresponds to proposal. Copy changes? might appear when you try to activate the data source. Press simply Yes.

/wp-content/uploads/2015/01/fig_7_621321.jpg


To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply