6
The type of character used to identify special characters and reserved SQL keywords,
such as WHERE. The Data Integration Service places the selected character around
special characters and reserved SQL keywords. The Data Integration Service also
uses this character for the Support Mixed-Case Identifiers property.
Support Mixed-Case Identifiers
When enabled, the Data Integration Service places identifier characters around table,
view, schema, synonym, and column names when generating and executing SQL
against these objects in the connection. Use if the objects have mixed-case or
lowercase names. By default, this option is not selected.
Type of database to which ODBC connects. For SAP HANA, select Other.
Creating an ODBC Connection in the Administrator Tool
The Data Integration Service uses database connections to process integration objects for the
Analyst tool and the Developer tool. Integration objects include mappings, data profiles,
scorecards, and SQL data services.
1. Select the Domain tab, and click Connections.
2. In the Domain Navigator, click Actions > New > Connection.
3. Select the connection type ODBC.
4. Click OK.
5. Configure the connection properties.
6. Click Test Connection to verify the connection.
7. Click Finish.
Creating an ODBC Connection in the Analyst Tool
Create a connection to import relational data objects, preview data, run a profile on data, and run
mappings. The Analyst tool uses the connection when you import a data object. The Data
Integration Service uses the connection when you preview data, run a profile, or run mappings.
1. Click Manage > Connections.
2. Click New.
3. Enter a connection name, ID, optional description, and select database type ODBC.
4. Choose whether you need a Simple Connection or Advanced Connection.
If you choose an advanced connection, you need to fill in more connection information fields.
5. Configure the connection properties.
6. Click OK.
The Analyst tool tests the connection and displays the test status.
Creating an ODBC Connection in the Developer Tool
Create a connection before you import data objects, preview data, profile data, or run mappings.
1. Click Window > Preferences.
2. Select Informatica > Connections.
3. Expand the domain in the Available Connections list.
4. Select Databases > ODBC.
5. Click Add.
6. Enter a connection name and optional description.
7. Click Next.
8. Configure the connection properties.
9. Click Test Connection to verify the connection.
10. Click Finish.
(124 pages)
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Commentaires sur ces manuels