This add-on is operated by DQE SOFTWARE

Deduplication, Duplicate, Data Quality & Dedupe Management for Salesforce.

Last updated December 20, 2024

DQE One is an add-on to deduplicate, clean, and qualify your Heroku Postgres, Salesforce, and Data Cloud databases. The system operates as a microservice. Our managed package on Salesforce installs the interface, allowing you to launch and customize each process for deduplication, cleaning, and qualification.

This article shows how to install and manage the add-on. For instructions on how to use DQE One Server, see our documentation.

Prerequisites

Before provisioning the add-on, install the Heroku CLI.

Log in to your Heroku account and follow the prompts to create a SSH public key:

$ heroku login

Sample App with Heroku Deploy

Install this sample Python app that automatically adds the buildpacks required for the add-on.

If you want to create an app on your own, follow the instructions in Install Buildpacks.

Provisioning the Add-on

You can attach DQE One Server to a Heroku application via either the CLI:

$ heroku addons:create dqe-one-server:v1-1 --app your-app-name

Or by clicking Install DQE One in the Elements Marketplace.

Install Buildpacks

Requirements

You must install the Heroku Key-Value Store and CloudAMQP add-ons before using DQE One:

$ heroku addons:create heroku-redis:mini --app your-app-name

$ heroku addons:create cloudamqp:lemur --app your-app-name

Installation

After provisioning the add-ons, install these buildpacks:

• DQE One buildpack
• Heroku Python buildpack
• DQE Unify BSDDB3 buildpack

Install the DQE One buildpack:

$ heroku buildpacks:add --index 1 dqe-software/dqe-one-buildpack --app your-app-name
Buildpack added. Next release on dqe-one will use dqe-software/dqe-one-buildpack.
Run git push heroku main to create a new release using this buildpack.

Install the Heroku Python buildpack:

$ heroku buildpacks:add heroku/python --app your-app-name
Buildpack added. Next release on dqe-one will use dqe-software/dqe-one-buildpack.
Run git push heroku main to create a new release using this buildpack.

Install the DQE Unify BSDDB3 buildpack:

$ heroku buildpacks:add dqe-software/dqe-unify-bsddb3-buildpack --app your-app-name
Buildpack added. Next release on dqe-one will use:
  1. dqe-software/dqe-one-buildpack
  2. heroku/python
  3. https://buildpack-registry.s3.amazonaws.com/buildpacks/dqe-software/dqe-one-bsddb3-buildpack.tgz
Run git push heroku main to create a new release using these buildpacks.

Deploy the Heroku App

Clone the repository with git:clone to clone your app source code to your local machine. Then create a requirements.txt file in it:

$ heroku git:clone -a your-app-name
$ cd your-app-name
$ touch requirements.txt

Make some changes to the code you just cloned and deploy them to Heroku using the git commands:

$ git add .
$ git commit -am "first deploy"
$ git push heroku master

Launch DQE One

The DQE One buildpack contains a Procfile that creates two dynos that you must start:

$ heroku ps:scale worker=1 web=1 --app your-app-name
Scaling dynos... done, now running worker at 1:Hobby, web at 1:Hobby

Removing the Add-on

You can remove DQE One Server via the Heroku CLI:

$ heroku addons:destroy dqe-one-server --app your-app-name

Support

Submit all DQE One support and runtime issues via one of the Heroku Support channels. For other questions or suggestions, email us at support@dqe-software.com.