The following table describes the fields in the External Data Store screen.
|
Fields |
Description |
|
Fields marked in red asterisk(*) are mandatory |
|
|
Name |
Enter the name of the Source. |
|
Description |
Enter a description for the Source. |
|
Type |
The following source type for information on the additional fields specific to them are available: · DB2 Type · EBCDIC Type · File Type · HDFS Type · Hive Type · Oracle Type · SQL Server Type · Sybase Type · Teradata Type · XML Type |
IBM DB2 is a family of database server products. These products support the relational model.
When you select EDS Type as DB2, the following fields are displayed:
|
Field |
Description |
Comments |
|
JDBC URL |
Provide the URL of the Database. |
Example: jdbc:db2://<hostname>[:<port>]/<database> |
|
User ID |
Enter the User ID. |
|
|
Password |
Enter the password. |
|
|
Schema |
Enter the schema name. |
|
Extended Binary Coded Decimal Interchange Code (EBCDIC) File is a binary code for alphabetic and numeric characters.
When you select EDS Type as EBCDIC, the following fields are displayed:
|
Field |
Description |
Comments |
|
File Location |
Enter the absolute path of the data file landing area. |
ODI agent must be available and running in the server from where the data file is located. |
American Standard Code for Information Interchange (ASCII) File is a character-encoding scheme.
When you select EDS Type as File, the following fields are displayed:
|
Field |
Description |
Comments |
|
File Location |
Enter the absolute path of the data file landing area. |
ODI agent must be available and running in the server from where the data file is located. |
|
Encryption at Rest |
If a source file is encrypted or a destination file should be encrypted upon data extraction needs, choose the “Encryption at Rest” option and enter the Encryption Key File Path. |
· DIH must have access to the source file landing area. · The UNIX user, which is used for starting the agent, must have execution permission to DMT utility. Example: /landingzone/inputfiles |
Hadoop Distributed File System (HDFS) is an open-source and fundamentally a new way of storing and processing data. It enables distributed processing of huge amounts of data across industry-standard servers that both store and process the data, and can scale without any limits HDFS is Big Data in a raw format.
When you select EDS Type as HDFS, the following fields are displayed:
|
Field |
Description |
Comments |
|
JDBC URL |
Provide the URL of the Database. |
Example: hdfs://<Host>:<Port> |
|
File Location |
Enter the file location. |
|
Hive provides a mechanism to project structure onto the data in Hadoop and Big data in a tabulated format.
When you select EDS Type as Hive, the following fields are displayed:
|
Field |
Description |
Comments |
|
JDBC URL |
Provide the URL of the Database. |
Example: jdbc:hive://<Host>:<Port>/<Schema> |
|
Driver |
Enter the driver for the HIVE datastore. |
For example, to connect to Cloudera Hive server with JDBC 4.0 data standards, specify “com.cloudera.hive.jdbc4.HS2Driver” as a driver. See Cloudera document for more details about Cloudera JDBC drivers. |
|
If Kerberos is enabled: |
||
|
Principal User Name |
Enter the Principal User Name. |
|
|
Conf File Path |
Enter the Kerberos Conf File path. |
|
|
Key Tab Path |
Enter the path of the Key Tab file, generated for the principal user. |
|
|
If Kerberos is not enabled: |
||
|
User ID |
Enter the User ID. |
|
|
Password |
Enter the Password. |
|
An Oracle database is a collection of data treated as a unit. The purpose of a database is to store and retrieve related information.
When you select EDS Type as Oracle, the following fields are displayed:
|
Field |
Description |
Comments |
|
JDBC URL |
Provide the URL of the database. |
Example: jdbc:oracle:thin:@//<hostname>:<port>/<servicename> |
|
User ID |
Enter the User ID. |
|
|
Password |
Enter a password. |
|
|
Schema |
Enter the Schema name in upper case. |
|
|
Encryption in Transit |
Choose this option if you want the data to be encrypted while reading from the source. |
|
Microsoft SQL Server is a relational database management system. It is a software product with the primary function of storing and retrieving data as requested by other software applications, which may run either on the same computer or on another computer across a network.
When you select EDS Type as SQL Server, the following fields are displayed:
|
Field |
Description |
Comments |
|
JDBC URL |
Provide the URL of the database. |
Example: jdbc:sqlserver://<hostname>\SQLExpress |
|
User ID |
Enter the User ID. |
|
|
Password |
Enter the password. |
|
|
Schema |
Enter the Schema name. |
|
Sybase produces software to manage and analyze information in relational databases.
When you select EDS Type as Sybase, the following fields are displayed:
|
Field |
Description |
Comments |
|
JDBC URL |
Provide the URL of the database. |
Example: jdbc:sybase:Tds:<hostname>:<port> |
|
User ID |
Enter the User ID. |
|
|
Password |
Enter the password. |
|
|
Schema |
Enter the Schema name. |
|
Teradata Corporation provides analytic data platforms, applications, and related services. Its products enable users to consolidate data from different sources and make the data available for analysis.
When you select EDS Type as EBCDIC, the following fields are displayed:
|
Field |
Description |
Comments |
|
JDBC URL |
Enter the URL of the database. |
Example: jdbc:teradata://<hostname> |
|
User ID: |
Enter the User ID. |
|
|
Password |
Enter the password. |
|
|
Schema |
Enter the Schema name. |
|
Extensible Markup Language (XML) is a markup language that defines a set of rules for encoding documents.
When you select EDS Type as XML, the following fields are displayed:
|
Field |
Description |
Comments |
|
File Location |
Enter the absolute path of the data file landing area. |
The ODI agent must be available and running in the server where the data file is located. |