Technical Vendors in Intelligence

Port - 5439

jdbc:postgresql://HOST:PORT/DATABASE?user=USER&password=PASSWORD

S3 Bucket Name – The highest hierarchy in S3

Directory – The folder, inside the bucket, from which you want to retrieve files.

Host/Port - Enter host, port should be 22

User - enter username and password

Use Private Key Authentication - If you are using private key authentication, enter it here.

Directory - Enter the relevant directory with the location of the file.

Credentials - Add your Box.com credentials

Directory - Enter the relevant directory with the location of the file. Note that when using the Box.com the directory should include the folders' ID's and not the folder names. Folder ID's can be retrieved from the URL in the provider's platform.

Credentials - Add your Dropbox credentials

Directory - Enter the relevant directory with the location of the file.

Team Space - Select to retrieve files from team space

Host/Port

Connection Mode – Set according to your settings

Credentials (User/Pass) - Enter your username and password

Directory – The folder in which the relevant file is located

Security Mode – Set according to your settings

Credentials - Add your Google credentials

Directory - Enter the relevant directory with the location of the file.

Credentials - Add your credentials (identical to the Google Big Query credentials)

Bucket Name The highest hierarchy in Google Storage

Directory - The file location.

Port 5432

jdbc:postgresql://HOST:PORT/DATABASE?user=USER&password=PASSWORD

Host/Port - Enter both host and port

HDFS User - Enter username only, no password required.

HDFS Directory

Port - 5433

jdbc:vertica://HOST:PORT/DATABASE?user=USER&password=PASSWORD

File Extension – In case the URL does not lead to a specific file, enter the file extension so that the system will know how to process the file.

Authentication Type – None means there is no need for authentication. Basic authentication type will require you to enter user and password.

Headers -

POST Body (Optional) – You can add further information to the request

Connection String - Insert the connection details which can be found in the 'Access Keys' tab. For example:

DefaultEndpointsProtocol=https;AccountName=ACCOUNT_NAME;
AccountKey=ACCOUNT_KEY;EndpointSuffix=core.windows.net

Container - Enter the relevant container where your blobs (files) can be found

Port - 1433

jdbc:sqlserver://HOST:PORT;database=DATABASE;user=USER;password=PASSWORD

mongodb://USER:PASSWORD@HOST:PORT/DATABASE.COLLECTION

Mongo DB expects to receive a basic JSON file, without an array of nested values. If the JSON file you upload is structured differently than the default structure, you may need to make changes in the transformers to ensure MCI can digest the file properly.

Credentials - Add your credentials.

Directory - Enter the relevant directory with the location of the file. For example, if the path is Files > Shared > Mapping Tables, use: /Shared/Mapping Tables

Note: we do not support a connection in the OneDrive connector with a folder used for integration with other Microsoft services - for example SharePoint. We do however support connections with Shared folders - so if possible, move the files to a shared folder, enabling Datorama to retrieve them with the proper path.

Credentials - Add your credentials.

Directory - Enter the relevant directory with the location of the file. For example, if the path is Files > Shared > Mapping Tables, use: /Shared/Mapping Tables

To link your OneDrive account to SharePoint, click Use Sharepoint and entering your SharePoint site name.

Microsoft Graph API permissions must be enabled in your SharePoint account.

Note: We support connections with Shared folders - so if possible, move the files to a shared folder, enabling Marketing Cloud Intelligence to retrieve them with the proper path.

Port - 1521

jdbc:oracle:thin:USER/PASSWORD@HOST:PORT:SID

File Extension – In case the URL does not lead to a specific file, enter the file extension so that the system will know how to process the file.

Authentication Type – None means there is no need for authentication. Basic authentication type will require you to enter user and password.

Headers

POST Body (Optional) – You can add further information to the request, for example, parameters

port - 30015

jdbc:sap://HOST:PORT/DATABASE?user=USER&password=PASSWORD

Credentials: Add your SmartSheet Credentials

Folder/Workspace ID: Enter either the Folder ID or the Workspace ID. Leaving this box empty will retrieve data from the 'Sheets' root folder

Connection String:

jdbc:snowflake://ACCOUNT_NAME.snowflakecomputing.com/?warehouse=WAREHOUSE
&db=DATABASE&schema=SCHEMA&role=USER_ROLE

Credentials: Enter your User Name and Password