Select Data Source - trillium_discovery

To enable Discovery Center repositories to connect to your data, the repository administrator must set up at least one data connection for each type of external data file with which you intend to work. Data connections allow Trillium repositories used by the Discovery Center to import from or link to both flat file data sources and relational databases.

You can also add a data source by directly loading a delimited data file from your local system. This method allows you to bypass the dependency on a data connection and is useful to quickly upload a sample data file from your local system to the Discovery Center for analysis.

Table 1. Data source types the repository imports or links to
Data Source Type	Description
Delimited files	Delimited flat text files and comma-separated value (CSV) files: With ASCII, extended ASCII, or hexadecimal delimiters With or without ANSI DDL schema
COBOL copybook	Flat, fixed-length files described by COBOL copybooks: Character encoding including, but not limited to, ASCII, EBCDIC, and Unicode Big- or Little-Endian byte orders One- or two-byte data alignment
Relational data	Relational data stored in a Relational Database Management System (RDBMS) application. Discovery Center can import or link using: Direct connection to Oracle and IBM DB2 databases Vendor-supplied (native) ODBC-compliant RDBMS connection RDBMS extraction into a delimited file with a corresponding ANSI DDL schema
TSQ files	File generated by the Trillium application or fixed-length files with DDL schema.

CyberArk Security Integration

Discovery Center and Control Center can be integrated with your company’s CyberArk account security solution to make retrieving and passing database credentials more secure.

To use the integration, when you add a data source (entity) that uses a data (loader) connection to a password-protected database, rather than entering the database user ID and password, supply CyberArk credentials. Then, each time the data connection accesses a password-protected ODBC database, the database credentials are retrieved from an encrypted digital vault on a centralized CyberArk server. The credentials are unique for each data source you add. Even when CyberArk is configured, you still have the option to enter your standard database user name ID and password.

Note: Ensure the CyberArk password vault URL has been configured by your administrator for your software instance. If not, you will not be prompted for the CyberArk credentials.

To import from the server system and select data connection

Do one of the following:
- From the navigation menu, click Data Discovery > Add Data Source.
- From a data source search results page, click Add Data Source.
The Add Data Source window opens to the Select tab.
For Import from, ensure Data connection is selected (it is the default).
In the Data Connection list, click the name of the data connection associated with the external data file you want to use. (If there is a long list of names, enter some or all of the name in the Filter field to filter the list.) The Data Source list populates with the names of all external data source files associated with that connection. If the list does not populate, verify with your Trillium repository administrator that the connection is valid and that files associated with that connection are available. Only files and directories for enabled connections display.
Using RDBMS connections
If you select an RDBMS connection (for example, Oracle, DB2, or ODBC), you may be prompted for your user credentials if security has been configured for the connection to the database server.

Do one of the following:
- For standard RDBMS connections (without CyberArk) enter your database User ID and Password and click Submit.
- If Trillium Discovery is integrated with CyberArk and you select an ODBC connection, specify the following information (supplied by your CyberArk administrator) to be used to access the data connection:
  Credential Type. Click the drop-down list and select the credentials to use when accessing the data connection, either CyberArk (the default) or ODBC Standard. If you select ODBC Standard, enter your database User ID and Password. Click Show to show the password and Hide to mask it again.
  
  Application ID. Enter the CyberArk Application ID used to access the data connection.
  
  CyberArkQuery. Enter the unique query to be used as the filter criteria to retrieve the password credentials. For example, Safe=AWSafe;Object=Database-MSSql-admin-cdqdb
  
  Certificate Path. (Optional) If your CyberArk solution is configured to authenticate calls to the vault using a client certificate, enter the certificate path.
Click Submit. If the data connection cannot be accessed, an error message displays. Click System Error Messages to see more information.
In the Data Source list, click a data source file name. If needed, use the Filter to narrow the list.

Note: For file names, you can include the file extension in the filter criteria.
Do one of the following:
- Click Continue to save your settings and open the Configure tab. See Configure Data Source.
- Click Cancel (or X) to close the Add Data Source window without saving your work.

Import from the Client System

To import from the client system

Do one of the following:
- From the navigation menu, click Data Discovery > Add Data Source.
- From a data source search results page, click Add Data Source.
The Add Data Source window opens to the Select tab.
For Import from, select Local file system.
Click Browse. The Choose file to Upload window opens.
Navigate to and select the file you want to upload.
Select the file type. For example, for .txt and .csv files, select Custom Files.
Click Open. The File Name field populates with the name of the selected file. The selected file will be uploaded to the server in the following directory: C:\ProgramData\Trillium Software\MBSW\17.3\Data\import\_upload\username.

If the message Unable to transfer file displays, click Browse to select another file or change the file type. If you select a file with the same name as a file in the server's import\_upload\username directory, the uploaded file will be preceded by a unique ID.
Do one of the following:
- Click Continue to save your settings and open the Configure tab. See Configure Data Source.
- Click Cancel (or X) to close the Add Data Source window without saving your work.

Select Data Source - trillium_discovery - Latest

Trillium Discovery Center

Import from the Client System