发帖
雷达卡
Data Service.pdf
(2.29 MB, 需要: 8 个论坛币)
SAP的BO商业智能分析软件数据服务介绍
Chapter 1 Introduction.............................................................................................................................7
1.1 Welcome to SAP BusinessObjects Data Services...................................................................7
1.1.1 Welcome.................................................................................................................................7
1.1.2 Documentation set for SAP BusinessObjects Data Services...................................................8
1.1.3 Accessing documentation......................................................................................................10
1.1.4 SAP BusinessObjects information resources.........................................................................11
Chapter 2 Upgrading to SAP BusinessObjects Data Services XI 4.0....................................................13
2.1 Major changes in Data Services XI 4.0...................................................................................13
2.2 Upgrading Data Services.......................................................................................................13
2.3 Backing up repositories, configuration files, and Data Cleanse files ......................................14
2.4 Uninstalling the previous version of Data Services or Data Integrator....................................15
2.5 Installing SAP BusinessObjects Data Services XI 4.0.............................................................15
2.6 Upgrading repositories...........................................................................................................16
2.7 Migrating users, repositories, and other objects.....................................................................16
2.7.1 Using Upgrade Manager........................................................................................................17
2.7.2 Migrating all objects...............................................................................................................18
2.7.3 Migrating separate objects.....................................................................................................18
2.7.4 Additional Upgrade Manager examples..................................................................................26
2.7.5 Error messages......................................................................................................................26
2.7.6 Running Upgrade Manager with SSL-enabled CMS...............................................................27
2.8 Migrating real-time services configurations.............................................................................28
2.9 Verifying the upgrade process................................................................................................28
Chapter 3 Data Services Behavior Changes..........................................................................................31
3.1 Behavior changes in version 14.0.0........................................................................................31
3.1.1 Management Console............................................................................................................32
3.1.2 Designer................................................................................................................................33
3.1.3 64-bit on Windows and Linux.................................................................................................33
3.1.4 Central repository users and groups......................................................................................34
3.1.5 Importing and exporting objects.............................................................................................34
3.1.6 SSL protected communication channels.................................................................................34
3 2011-06-09
3.1.7 BusinessObjects Enterprise Metadata Integrator...................................................................35
3.1.8 Microsoft Excel......................................................................................................................35
3.1.9 Joins in the Query transform..................................................................................................35
3.1.10 Unsupported BWA datastore database type..........................................................................36
3.1.11 SAP NetWeaver RFC library..................................................................................................36
3.1.12 ODBC usability on UNIX........................................................................................................37
3.1.13 Auto Documentation image display........................................................................................38
3.1.14 Data Quality support for NULL values....................................................................................38
3.1.15 Data Quality support for native data types..............................................................................39
3.1.16 Data Cleanse solution............................................................................................................39
3.1.17 Global Address Cleanse transform.........................................................................................42
3.1.18 Global Suggestion List transform...........................................................................................47
3.1.19 Match transform.....................................................................................................................47
3.1.20 USA Regulatory Address Cleanse transform.........................................................................48
3.1.21 GeoCensus and Geocoder....................................................................................................56
3.2 Behavior changes in version 12.2.1........................................................................................60
3.2.1 Microsoft SQL Server 2008 database support.......................................................................60
3.2.2 WSDL version.......................................................................................................................60
3.3 Behavior changes in version 12.2.0........................................................................................61
Before upgrading SAP BusinessObjects Data Services or SAP BusinessObjects Enterprise
..............................................................................................................................................61
3.3.1
3.3.2 Data Cleanse migration considerations..................................................................................62
3.3.3 USA Regulatory Address Cleanse transform.........................................................................65
3.3.4 Export reports........................................................................................................................67
3.3.5 Target table editor option tab.................................................................................................68
3.3.6 Fixed-width File Format..........................................................................................................68
3.3.7 Pushdown SQL operations.....................................................................................................69
3.3.8 Citrix support.........................................................................................................................69
3.3.9 Bundled SAP libraries.............................................................................................................70
3.3.10 RFC Server support change...................................................................................................70
3.3.11 Additional datetime information in overflow file.......................................................................70
3.3.12 Web service security settings................................................................................................70
3.3.13 Unsupported database versions.............................................................................................71
3.3.14 UNIX $LINK_DIR directories..................................................................................................71
3.4 Behavior changes in version 12.1.1........................................................................................72
3.4.1 Netezza table name syntax change........................................................................................72
3.4.2 Netezza bulk loading..............................................................................................................72
3.4.3 Neoview bulk loading.............................................................................................................73
3.4.4 Blob data type enhancements................................................................................................73
3.5 Behavior changes in version 12.1.0........................................................................................74
3.5.1 Cleansing package changes...................................................................................................74
4 2011-06-09
Contents
3.5.2 DTD-to-XSD conversion.........................................................................................................75
3.5.3 Minimum requirements for international addressing directories..............................................75
3.5.4 Try/catch exception groups....................................................................................................76
3.5.5 Upgrading from version 12.0.0 to version 12.1.0....................................................................78
3.6 Behavior changes in version 12.0.0........................................................................................78
3.6.1 Case transform enhancement................................................................................................79
3.6.2 Data Quality projects in Data Integrator jobs .........................................................................79
3.6.3 Data Services web address...................................................................................................79
3.6.4 Large object data type enhancements....................................................................................80
3.6.5 License keycodes..................................................................................................................82
3.6.6 Locale selection.....................................................................................................................82
3.6.7 ODBC bigint data type...........................................................................................................84
3.6.8 Persistent and pageable cache enhancements.......................................................................84
3.6.9 Row delimiter for flat files.......................................................................................................84
3.7 Behavior changes in version 11.7.3........................................................................................85
3.7.1 Data flow cache type..............................................................................................................85
3.7.2 Job Server enhancement.......................................................................................................85
3.7.3 Logs in the Designer..............................................................................................................86
3.7.4 Pageable cache for memory-intensive data flows...................................................................86
3.7.5 Adapter SDK.........................................................................................................................86
3.7.6 PeopleSoft 8..........................................................................................................................86
3.8 Behavior changes in version 11.7.2........................................................................................87
3.8.1 Embedded data flows.............................................................................................................87
3.8.2 Oracle Repository upgrade.....................................................................................................87
3.8.3 Solaris and AIX platforms.......................................................................................................89
3.9 Behavior changes in version 11.7.0........................................................................................89
3.9.1 Data Quality...........................................................................................................................89
3.9.2 Distributed data flows............................................................................................................91
3.9.3 JMS Adapter interface...........................................................................................................92
3.9.4 XML Schema enhancement...................................................................................................92
3.9.5 Password management..........................................................................................................92
3.9.6 Repository size......................................................................................................................93
3.9.7 Web applications....................................................................................................................93
3.9.8 Web services.........................................................................................................................93
3.9.9 WSDL version.......................................................................................................................93
Chapter 4 Data Quality to Data Services Upgrade................................................................................95
4.1 Overview of migration............................................................................................................95
4.1.1 Data Quality to Data Services Upgrade..................................................................................95
4.1.2 Who should migrate?.............................................................................................................95
4.1.3 Why migrate?.........................................................................................................................96
5 2011-06-09
Contents
4.1.4 Introduction to the interface...................................................................................................97
4.1.5 Downloading blueprints and other content objects.................................................................99
4.1.6 Introduction to the migration utility..........................................................................................99
4.1.7 Terminology in Data Quality and Data Services....................................................................100
4.1.8 Naming conventions.............................................................................................................101
4.1.9 Deprecated objects..............................................................................................................102
4.1.10 Premigration checklist..........................................................................................................104
4.2 Using the migration tool.......................................................................................................105
4.2.1 Overview of the migration utility...........................................................................................105
4.2.2 Migration checklist...............................................................................................................106
4.2.3 Connection information........................................................................................................106
4.2.4 Running the dqmigration utility .............................................................................................108
4.2.5 dqmigration utility syntax and options...................................................................................110
4.2.6 Migration report ..................................................................................................................112
4.3 How Data Quality repository contents migrate.....................................................................113
4.3.1 How projects and folders migrate.........................................................................................114
4.3.2 How connections migrate.....................................................................................................118
4.3.3 How substitution files and variables migrate.........................................................................123
4.3.4 How data types migrate.......................................................................................................126
4.3.5 How Data Quality attributes migrate.....................................................................................127
4.4 How transforms migrate.......................................................................................................127
4.4.1 Overview of migrated transforms.........................................................................................127
4.4.2 Address cleansing transforms..............................................................................................133
4.4.3 Reader and Writer transforms..............................................................................................141
4.4.4 How Data Quality integrated batch Readers and Writers migrate.........................................169
4.4.5 How Data Quality transactional Readers and Writers migrate...............................................174
4.4.6 Matching transforms............................................................................................................177
4.4.7 UDT-based transforms.........................................................................................................185
4.4.8 Other transforms..................................................................................................................193
4.4.9 Suggestion Lists options......................................................................................................204
4.5 Post-migration tasks............................................................................................................204
4.5.1 Further cleanup ...................................................................................................................205
4.5.2 Improving performance ........................................................................................................211
4.5.3 Troubleshooting...................................................................................................................214
Index 221
提升卡
置顶卡
沉默卡
变色卡
抢沙发
千斤顶
显身卡
zhenduo 
京公网安备 11010802022788号
