Articles in this section

See more

Duco Data Platform Quickstart Guide

  • Updated
  • ~ minute read
Follow

Before you can connect to the Duco Data Platform from your chosen reporting tool you will need to:

  • Provide Support with the list of IP addresses that you will be connecting from
  • Confirm that you can connect to your Data Platform environment on port 21050
  • Install the appropriate Impala ODBC driver for your BI tool

Confirming Connectivity

The Data Platform requires outbound communication over port 21050. The SSL encryption used is identical for Duco, but since this is a non-standard port for many organisations, we recommend confirming connectivity either with your network team or by using the following steps:

Step 1: Run Telnet

Open a command prompt on your computer.

  • Windows 7​: Start > All Programs > Accessories > Command Prompt
  • Windows 8 & 10​: Start > All Apps > Windows System > Command Prompt
  • Mac OS X​: Applications > Utilities > Terminal
  • Linux​: Open Terminal or another command prompt for your distribution

Enter the telnet command for your Duco instance:

 > telnet <your client id>.duco-app.com 21050

 

Step 2: Read the telnet response

If your command prompt shows the following Connected message, your machine can successfully connect to the Data Platform: 

> telnet <your client id>.duco-app.com 21050
    Trying 192.0.2.1...
    Connected to <your client id>.duco-app.com.
    Escape character is '^]'.

 

If your command prompt shows anything else, your machine cannot connect to the Data Platform. Common failure messages can include: connection refused, operation timed out unable to connect to remote host & no response.

 

Installing ODBC Driver

The Cloudera ODBC Driver to connect to the Data Platform can be downloaded directly from Cloudera: https://www.cloudera.com/downloads/connectors/impala/odbc/

Please follow the installation instructions from Cloudera for installing this in your environment.

 

Adding Data Source to BI Tool

The ‘Data Source’ type to connect to your Data Platform depends on the BI tool being used. eg:

  • Tableau​: Connect > To a Server > Cloudera Hadoop
  • PowerBI​: Get Data > Database > Impala

 

Authentication

Please contact your CSE to obtain your Data Platform username & password. To connect, input these credentials, ensuring that the ‘Enable SSL’ checkbox is checked.

 

Finding Data

Your data is available in the <your client id>_data schema. Once connected, you should be able to see a number of tables: 

 mceclip0.png

You’re now ready to start building reports.

Related articles