ConnectWise - Manage
ConnectWise is a leading software company dedicated to the success of IT solution providers, including ITSP and software for MSP's.
Connecting to ConnectWise - Manage, you need to make sure that:
- You or the user configuring ConnectWise - Manage has administrative access to the cloud based application.
DataLakeHouse.io securely connects to your ConnectWise - Manage system. Using the form in the DataLakeHouse.io portal after selecting this source connector, please complete the following basic steps:
Using the form please complete the following basic steps:
- Enter a Name or Alias for this connection, in the 'Name/Alias' field, that is unique from other connectors.
- Enter in the 'Target Schema Prefix' field, a name that will be unique in your target cloud warehouse destination database where you wish to land the data.
- Enter the 'Host URL' for this ConnectWise - Manage API integration
- Enter the 'Company Id' for this ConnectWise - Manage API integration
- Enter the 'Public Key' for this ConnectWise - Manage API integration
- Enter the 'Private Key' credential for this ConnectWise - Manage API integration
- Click the Authorize Your Account button which will save the connection.
The easiest way to determine this is by looking at the URL you use to access ConnectWise Manage.
- Connect to CW Manage and login
- After you've logged in and are in the app, look at the URL and write i down.
- ConnectWise Cloud URLs
- https://na.myconnectwise.net - North America
- https://eu.myconnectwise.net - EU
- https://aus.myconnectwise.net - APAC
- https://za.myconnectwise.net - South Africa
If the URL is NOT listed in the above list, most likely you are considered "on-prem" for ConnectWise Manage and need to go to the next section below.
You can also look within the CW Manage System module here which will show your URL is the format of connect.<companyname>.com
In order to establish a secure connection to ConnectWise - Manage a set of API keys need to be created in ConnectWise.
Create an API Account
- In ConnectWise Manage, go to System > Members
- Select the ‘API Members’ tab
- Click + to add an account
- Enter “DataLakeHouse” in the Member ID field
- Enter “DataLakeHouse” in the Member Name field
- Set the Department field to Admin or similar
- Set Name field
- Set Default Territory field
- Click Save
Create a public and private API Key
- Select the ‘API Keys’ Tab
- Click + to add a new set of keys
- Enter DataLakeHouse.io
- Click save and capture the keys. The Private Key is only available one time so save this key!
