Connecting to an HBase database

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

How to create an HBase 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 HBase 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 HBase system.

1 In Database URL, type the URL to the HBase 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‑21 shows an example of properties to connect to an HBase Hive data source.

Figure 6‑21 Connection properties for an HBase Hive data source