EDI Accelerator Guide

10.2.3
- 10.5.3
- 10.5.0
- 10.4.0
- 10.2.2
- 10.2.1
- 10.2

Back Next

Installing and Configuring the EDI Partner Import Tool

Before you perform partner on-boarding with the EDI Partner Import Tool, set up the relevant PowerCenter workflow and enter the partner, account, profile, and endpoint data that you want to import into the EDI Partner Import Tool Excel template.

On the machine where you installed the PowerCenter client,

B2B Data Exchange

, and EDI Accelerator, copy the EDI Partner Import Tool Excel template file named

dx_ partners_import_tool_template.xlsx

from the directory

<EDI Accelerator installation>\EDI_Accelerator\PartnersImportTool\

to the directory that you choose. Use this copy as the input file for the EDI partner import process, not the original template. Save the template for future use.

In the PowerCenter Workflow Manager, create a PowerCenter relational connection named

B2BDX_Data

to the Oracle database that contains the staging tables.

In the PowerCenter Repository Manager, create a folder named

EDI_GW_ partners_import_tool

that will hold the EDI Partner Import Tool workflow.

In the PowerCenter Repository Manager, import the workflow named

wf_partners_import_tool_all_steps.xml

from the directory

<EDI Accelerator installation>\EDI_Accelerator\PartnersImportTool\PWC\

into the repository folder named

EDI_GW_Mass_Onboarding

On the machine where you installed the Data Transformation client, add the ServiceDB directories named

m_step_5_update_xlsx_with_status

and

mplt_xlsx_to_relational

$INFA_HOME/DataTransformation/ServiceDB

. Get the ServiceDB directories from the directory

<EDI Accelerator installation>\EDI_Accelerator\PartnersImportTool\DT_Services\

On the machine where you installed the PowerCenter client,

B2B Data Exchange

, and EDI Accelerator, run the SQL script named

create_staging_tables.sql

located in the directory

<EDI Accelerator installation>\EDI_Accelerator\PartnersImportTool\Oracle\

On the machine where you copied the EDI Partner Import Tool Excel input file, update the Excel input file with partner, account, profile, and endpoint data, and EDI Accelerator parameter settings.

To create a partner, in the

operation

field select

create

To delete a partner, in the

operation

field select

delete

In the PowerCenter Workflow Manager, update the workflow

wf_partners_import_tool_all_steps. s_m_step_1_normalize_xls_and_load_into_staging

with the full path for the EDI Partner Import Tool Excel input file.

Double-click the object

s_m_step_1_normatlize_xls_and_load_into_staging

In the

Edit Tasks

window select the

Mapping

tab.

In the

Task type

pane, select the source

mplt_xlsx_to_relational.Read_xls_file_path

In the

Properties

section, the path and file name of the

xls_file_path.txt

file are specified. This file contains a default path to the EDI Partner Import Tool Excel input file. Update the path in this file to match the location where you put the file.

If the

xls_file_path.txt

file does not exist, create it, and then add to it the path to the EDI Partner Import Tool Excel input file. Provide a path to the input file that you use for the import process, not the template file. The default path for the

xls_file_path.txt

file is defined in the workflow variable

$PMSourceFileDir

In the PowerCenter Workflow Manager, update the workflow parameters.

Select

Workflow

Edit

In the

Workflow Configuration

window select the

Variables

tab.

Define the workflow variables. The following table contains the workflow variables and their default values.

Option	Description
$$wkf_create_end_point	Indicates whether to create the B2B Data Exchange endpoints. Default is No.
$$WKF_DX_TOOL	The command line to create the B2B Data Exchange endpoints. Default is C:\Informatica\B2B\DataExchange\dx-tools\run-cli.bat .
$$WKF_DX_CMD_LINE	A parameter used for the command line to create the endpoints. Default is com.informatica.b2b.dx.cli.importexport.ImportExportMain -c import
$$WKF_DX_USER	The B2B Data Exchange user name. Default is sys .
$$WKF_DX_PWD	The B2B Data Exchange password. Default is sys .
$$WKF_SPEC_FILE	The specification file to use with the EDI Partner Import process. Default is C:\Informatica\B2B\DataExchange\dx-tools\samples\import-all-specification-sample.xml .
$$WKF_END_POINT_FILE_SEND	The path of the XML file to used to create the send file endpoint. Default is $PMTargetFileDir\dx_endpoint_file_send.xml .
$$WKF_END_POINT_FILE_RECEIVE	The path of the XML file to used to create the receive file endpoint. Default is $PMTargetFileDir\dx_endpoint_file_receive.xml .
$$generate_xlsx_file_updated	Indicate whether to create a file with the status results of the EDI partner import process. Default is Yes.
$$generate_xlsx_result	The path of the file with the status results of the EDI partner import process. Default is C:\EDI\mass_onboarding\OUT\dx_partners_import_tool_RESULT.xlsx .
$$WKF_DX_Version	The version of B2B Data Exchange . Default is 10.1.