Data Source Properties

The Data Source Properties are as follows:

  • Name: The Data Source name must be unique and can contain A-Z, 0-9, all special characters (except a space), and characters from other languages too.
  • Description: The Data Source Description.
  • Delimiter Character: The delimiter character can be a Comma, Pipe, Semicolon, colon, Space, Tab or Other character chosen by the user.
  • Date Format: The date format must match the actual date format. If specified incorrectly, data may be rejected or loaded incorrectly. For example, if the date format is specified as MM/DD/YY, and the actual data is specified in DD/MM/YY, then 02/01/12 may be imported as Feb-01-2012 instead of Jan-02-20120.
  • Text Qualifier Character: The text qualifies can be a double quote, Single quote, or any other qualifies chosen by the user.
  • Use Column Names: If selected, the column names are the first row of the data in the file you are uploading. If not selected, you have to create the attribute names manually while creating the data source.
  • Start Import at Row Number: The row number from which the application starts importing data into the repository.
  • Format:
    • Delimited
    • Fixed Length
    • Database
  • Table Name: If you have selected the Database format, the Table Name field appears. The table name must be available in the TIBCO MDM database. You cannot connect to a different database.
  • Data File: Click the ... button next to the Data File field to navigate to and select the data source file. After you select the file, the selected filename appears.
  • Timestamp Format: Select the timestamp format in the Timestamp Format drop-down list. By default, YYYY-MM-DD HH:mm:ss.S timestamp format is displayed. If the actual data contains a different format, you can change it. The timestamp format must match the timestamp format used in the actual data. If you specify incorrect timestamp format, data may be rejected or loaded incorrectly.