Welcome to the Alteryx Knowledge Base
Knowledge Base / Alteryx One / How to include SSL certificates for on prem data sources when publishing to Alteryx One - Works...
How to include SSL certificates for on prem data sources when publishing to Alteryx One - Workspace Execution
Created/Edited -
How To
This article will walk through how to add self-signed or internal CA certificates to your workflow to be added temporarily to Alteryx One Workspace Execution's cloud store before your workflow executes. This is to ensure there are no certificate trust issues between Alteryx One's cloud environment and your desired on-prem data sources.
Environment
- Alteryx One
-
- Workspace Execution
Prerequisites
- You are connecting to one or more on prem data sources in your workflow which utilize a self-signed or internally signed certificate.
Note: we do not recommend self-signed certificates for production deployments - You have obtained the root certificate file(s) (.cer or .crt) for your on prem data source(s) from your IT personnel OR you obtained the Root certificate from Section 2 of the following article - Adding certificates for python-based connectors and other data sources
Procedure
- Open the existing workflow that is connecting to the on prem data source.
- Click into the canvas and press Ctrl + A to select all toolsets in the workflow
- Right-click one of the selected tools and select Add To New Control Container
- Navigate to Options->User Settings->Edit User Settings
- Under the General section, check the Display Asset Management in Properties Window box and then Save:
- Download the add-certs-to-cloud-store.yxmc macro attached at the bottom of the article
- Open your Designer workflow and choose one of the following:
- right-click anywhere on the Designer canvas and select Insert->Macro to choose the download macro to import into your worfklow
OR
-
- Add the macro to a new or existing macro repository and drag it to the canvos
- Right-click the macro and once again select Add To New Control Container
- Connect the end of the control container that contains the standalone macro to the beginning of the control container with your workflow logic created in Step #3, this should look something like this:
- Click on the macro once again and select the Assets icon in the macro configuration:
- On the bottom left pane, select Add File(s) under User added assets and select the root certificate(s) for your on prem data source(s) to package with the workflow:
- When ready, navigate to File->Save As->Alteryx One (or Save if you opened workflow directly from Alteryx One) and ensure the certificate file is included and checked as an asset to be packaged before publishing to Alteryx One and scheduling/running your workflow:
Attachments
Was this article helpful?