MITI Bridge Integrator Source

[Former Member]

Hi Experts,

I am trying to extract IBM InfoSphere DataStage metadata into SAP IS central repostiory for metadata managment impact and lineage analysis. For the i created MIMB integrator source with IBM InfoSphere DataStage type and used DataStage extract DSX file to import the metadata. The integrator source connection is succussfully created without any issues.

Then I ran the Integrator Souce to start extracting the metadata, the task is running from hours and still continueing. The Database log of the task is shwoing as below, and from there it is not moving further.

[I] 2014-04-09 08:33:33.014 Information Steward version
14.2.0.411.
[I] 2014-04-09 08:33:33.033 Starting utility
MITI.bridges.bo.mm.MimbIntegrator. (COR-10013)
[I] 2014-04-09 08:33:33.034
Process ID = 8080 on machine XXXXXXXXXXXXXXXXXX
[I] 2014-04-09
08:33:33.189 Connected to the Information Steward repository at
jdbc:sqlserver://XXXXXXXXXX:1433;databaseName=IS_REPO. (COR-10017)
[U]
2014-04-09 08:33:42.532 Argument -configurationObject = 54093 (COR-10206)
[U]
2014-04-09 08:33:42.532 Argument Encoding = iso-8859-2 (COR-10206)
[U]
2014-04-09 08:33:42.533 Argument File =
C:\Windows\TEMP\sda_dev_extract.5762502273886146081.dsx (COR-10206)
[U]
2014-04-09 08:33:42.534 Argument Import scope = All supported objects
(COR-10206)
[U] 2014-04-09 08:33:42.535 Argument Variable values file =
(COR-10206)
[U] 2014-04-09 08:33:42.536 Argument batch = true
(COR-10206)
[U] 2014-04-09 08:33:42.537 Argument batchRetryCount = 4,320
(COR-10206)
[U] 2014-04-09 08:33:42.538 Argument batchRetryInterval = 10,000
(COR-10206)
[U] 2014-04-09 08:33:42.538 Argument boeAuthentication =
secEnterprise (COR-10206)
[U] 2014-04-09 08:33:42.539 Argument
boeInfoObjectId = 54093 (COR-10206)
[U] 2014-04-09 08:33:42.542 Argument
boeServer = XXXXXXXXXXXXXXXXXXXXXXX(COR-10206)
[U] 2014-04-09
08:33:42.544 Argument boeUser = Administrator (COR-10206)
[U] 2014-04-09
08:33:42.544 Argument bridgeId = AscentialDataStage (COR-10206)
[U]
2014-04-09 08:33:42.546 Argument className = MITI.bridges.bo.mm.MimbIntegrator
(COR-10206)
[U] 2014-04-09 08:33:42.547 Argument deadlockRetryCount = 10
(COR-10206)
[U] 2014-04-09 08:33:42.548 Argument dl = INFO (COR-10206)
[U]
2014-04-09 08:33:42.549 Argument enableNewDBOptimization = true
(COR-10206)
[U] 2014-04-09 08:33:42.550 Argument fl = CONFIG
(COR-10206)
[U] 2014-04-09 08:33:42.551 Argument fullExtract = false
(COR-10206)
[U] 2014-04-09 08:33:42.551 Argument maxConnections = 10
(COR-10206)
[U] 2014-04-09 08:33:42.553 Argument repoConnectionTimeout =
3,600 (COR-10206)
[U] 2014-04-09 08:33:42.554 Argument repoOverridePermitted
= false (COR-10206)
[U] 2014-04-09 08:33:42.555 Argument sqlTopLimit =
1,000,000 (COR-10206)
[U] 2014-04-09 08:33:42.555 Argument validationLevel =
BASIC (COR-10206)
[I] 2014-04-09 08:33:43.125 Started execution on 2014-04-09
08:33:32. (COR-10014)
[I] 2014-04-09 08:33:43.780 Utility processing
starts.
[I] 2014-04-09 08:33:46.654 Running MIMB...

Environment Details:

SAP IPS : 4.0 SP 5

SAP Data Services: 4.2 SP0

SAP Information Steward: 4.2 SP0

Metadata Source : IBM InfoSphere DataStage 9.x

DataStage Extract Format used: .DSX

IS Repository Database: MS SQL SRV 2008 R2

Thanks,

Ramakrishna Kamurthy

[adrian_storen]

Does the integrator extract the DataStage information correctly?

I created one in IS 4.2 SP2, and get a number of warnings 'No summary maps found for RT activity' followed by "No lineage was created for the imported ETL model: No runtime activities or mapping models were found".

[Former Member]

Hi Adrian,

I too facing the same issue, finally after lot many tries i registered an incident in OSS for SAP support. But till now i didn't get any reply / resolution from SAP, will update you when i get reply from SAP. Also please update if you get find any solution.

Thanks,

Rama

[Former Member]

Hi All,

SAP fixed this in 4.2 SP3.1.

Thanks,

Rama

[Former Member]

Hi,

We resolved the issue by upgrading the application to latest version.

Thanks,

Ramakrishna Kamurthy

[Former Member]

Ramakrishna,  Which 'application' did you upgrade to latest version?

thx

Bruce McTavish

[Former Member]

Hi Bruce,

I upgraded IS to latest version (4.2 SP1 Patch 2)

Thanks,

Ramakrishna Kamurthy

[Former Member]

THANKS!  We're doing some initial work with getting data from InfoSphere into IS as well.  Lots of moving parts!