External services

Opinum Data Hub can by linked to external service to push or pull data:

Those connections can be done as an account level by managers, or at a user level by any users.

At an account level go on Account > Settings > and click on the Add External Service button. In the pop-up click on the service you want to add.

External services

FTP connection

  1. URL: enter the URL of the FTP, without http. A path can be specified here, if you need several files, just create several FTP in your account. The path can also be set at a report level.

  2. Type: Opinum Data Hub supports FTP, SFTP and FTPS

For FTP and FTPS, just enter the credentials of the FTP and click on Save. For SFTP a certificate should be added in the format OpenSSH. A OpenSSH key always starts by « -----BEGIN RSA PRIVATE KEY-----». You can convert a key into OpenSSH format with PuTTY Key Generator (puttygen) https://www.chiark.greenend.org.uk/~sgtatham/putty/latest.html

  1. Launch puttygen
  2. Import the certificate to convert with the menu Conversions [Symbol] Import key
  3. Export OpenSSH key

Once the FTP is defined, it can be used on each reports. Learn more about Report notifications.

Power BI

You can connect Power BI to Opinum Data Hub at a user level or at an account level:

  • User level: the connection will be available only for the user. Go to your Profile page and click to the Add new link.
  • Account level (managers only): all the users of the account can use the Power Bi account connected. Go to you Account settings page, in the Services tab and click on the Add linked service button.

In both case a pop-up opens with all the services that can be connected to Opinum Data Hub. Click on the Power BI logo, the Power PI connection pop-up opens. Enter your username and password and Save. Your Power BI account is now connected to Opinum Data Hub. You can send data into Power BI and display Power Bi tile in Data Hub dashboard.

Tip

Learn more about Power BI integration.

Azure Table Storage

You can connect Azure Table Storage to Opinum Data Hub at a user level or at an account level:

  • User level: the connection will be available only for the user. Go to your Profile page and click to the Add new link.
  • Account level (managers only): all the users of the account can use the Azure Table Storage account connected. Go to you Account settings page, in the Services tab and click on the Add linked service button.

In both case a pop-up opens with all the services that can be connected to Opinum Data Hub. Click on the Azure Table Storage logo, and enter your connection string: name and account key. You will find those information in your Azure Table Storage settings. Your Azure table storage is now connected to Opinum Data Hub, you can send data into into with reports.

Note

Please, note that if you choose to send your report to Azure Table Storage, the names you give to your report's sheets will be the names assigned to the Azure's tables. Therefore, these names must conform to Microsoft's rules

Tip

Learn more about reports.

Smappee

Click on the Smappee logo. the Smappee credentials pop-up opens.

Smappee credentials

Enter the username and the password of your Smappee account and click on the Save button.

You are now ready to create a Smappee source.