User manual BUSINESS OBJECTS DATA INTEGRATOR 11.0.1.0 FOR WINDOWS AND UNIX SUPPLEMENT FOR SIEBEL

[. . . ] Data Integrator Supplement for Siebel Data Integrator Supplement for Siebel Data Integrator 11. 0. 1. 0 for Windows and UNIX 1 Copyright If you find any problems with this documentation, please report them to Business Objects S. A. Trademarks Business Objects, the Business Objects logo, Crystal Reports, and Crystal Enterprise are trademarks or registered trademarks of Business Objects SA or its affiliated companies in the United States and other countries. [. . . ] You can import tables (including table and column descriptions) and function metadata. Data Integrator also displays information from both the logical business objects and user interface layers of Siebel applications. This makes it easier to find and import tables. Figure 1-1 :Siebel Architecture Physical User Interface Layer User Interface Objects Layer Siebel Application Business Objects Layer Data Objects Layer DBMS Third-party database vendor MS SQL Server is the only database that the Siebel interface supports. Install the drivers you need to connect MS SQL Server with Data Integrator on the same computers on which you install the Data Integrator Designer and Job Server components. See "System requirements" on page 43 of the Data Integrator Getting Started Guide for general information about Windows software and hardware requirements. The Siebel interface supports Siebel version 7. 5. 2 and higher compatible versions. For more information about licence-controlled interfaces for Data Integrator, see "Optional license-controlled features" on page 57 of the Data Integrator Getting Started Guide. Data Integrator Supplement for Siebel 7 1 Siebel Interface Datastores Security Because Data Integrator connects to Siebel applications through a database connection, Data Integrator can see all Siebel application objects that the provided MS SQL Server database user can access without requiring the application's user login security information. Datastores Data Integrator uses datastore connections to link with other applications or databases. · · In a design environment, use a datastore to browse or import metadata that represents external tables and other database objects. In a production environment, Data Integrator uses datastore information to move data between source and target databases and applications. After defining a Siebel datastore in Data Integrator, you can browse tables by type, or drill down on business components or Siebel repositories to find the tables you want to import. You can also import tables, functions, and business components by name. This section discusses: · · · Defining a Siebel datastore Browsing and importing metadata Extracting data from Siebel applications Defining a Siebel datastore With a Siebel datastore connection, you can browse Siebel application metadata. To define a Siebel datastore In the object library of the Data Integrator Designer, go to the Datastores tab Right-click inside the object library window and select New. In the Datastore Editor window, enter a name for this datastore (DS_SiebelApps, for example). 5. 8 Data Integrator Supplement for Siebel Siebel Interface Datastores 1 See "Database datastores" on page 66 of the Data Integrator Reference Guide for MS SQL Server connection options and descriptions. The Siebel datastore appears in the object library. Browsing and importing metadata After creating a Siebel datastore, you can browse and import the metadata from the connected application. [. . . ] For example, import all the tables in a business component then add select statements, joins, and mappings using the Designer to create the same associations used in your Siebel application. You can also import Siebel metadata by right-clicking a Siebel datastore in the object library and selecting Import by name. Data Integrator Supplement for Siebel 11 1 Siebel Interface Datastores Once tables are imported, you can view column names, data types, and business names for use in creating jobs. Extracting data from Siebel applications When extracting data from Siebel applications, Data Integrator processes and converts data types appropriately. For data type conversion details, see "Data type processing" on page 240 of the Data Integrator Reference Guide. 12 Data Integrator Supplement for Siebel Index A application user login security 8 C customer support 6 D Data Integrator support 6 datastore Siebel 8­9 H hardware and software requirements 7 I importing metadata 7 S security login information 8 Siebel architecture 7 Siebel datastore 8 support, Data Integrator 6 V version support 7 Data Integrator Supplement for Siebel 13 Index 14 Data Integrator Supplement for Siebel [. . . ]