Connecting to a Cloudera database

BIRT Designer Professional provides a JDBC driver to connect to a Cloudera system through Hive. Similar to connecting to a database, you provide the URL to the Hive machine and your user credentials.

How to create a Cloudera data source

1 In Data Explorer, right-click Data Sources, then choose New Data Source.

2 In New Data Source, specify the following information:

1 Select Cloudera Hive Data Source from the list of data source types.

2 In Data Source Name, type a name for the data source.

3 Choose Next.

3 In New Hive Data Source Profile, specify the properties to connect to the Cloudera system.

1 In Database URL, type the URL to the Cloudera system.

2 In User Name and Password, type the user credentials to connect to the system.

3 In Add File Statement, optionally type one or more Add File statements to add script files to the Hadoop distributed cache. Separate each Add File statement with a semicolon.

Figure 6‑14 shows an example of properties to connect to a Cloudera Hive data source.

Figure 6‑14 Connection properties for a Cloudera Hive data source