...
| Table of Contents | ||||
|---|---|---|---|---|
|
Overview
You can configure a new SQL Server account in Fast Data Loader (FDL) by using the user credentials from your existing account in SQL Server.
Prerequisites
Login credentials and access to SQL Server account. Contact your administrator, if you do not have access or settings details.
For more information on SQL Server account, see SQL Server documentation.Access to SQL Server enterprise snap pack in SnapLogic’s Intelligence Integration Platform. For more information, see SQL Server Account
Supported Versions
SnapLogic supports SQL Server 2008 to 2016. The Fast Data Loader was tested against SQL Server 11.00.2100.
Account Settings
Parameter Name | Data Type | Description | Example |
|---|---|---|---|
Create new connection tag | String | Required. Enter a name that will help identify your SQL Server account in FDL. | FDL_SQL Account |
Hostname | String | Required. Enter the target server address. | 54.98.196.248 |
Port Number | String | Required. Enter the database server's port to connect to. | 1433 |
Database name | String | Required. Enter the database name to connect to. | ReportServer |
Username | String | Enter a valid username that is allowed to connect to the database. This username is used as the default for retrieving connections. | WIN-USERS\fdl |
Password | String | Enter a valid password to connect to the database. Password is used as the default password for retrieving connections. | S0F^q7&M |
Troubleshooting
You might encounter the following errors when you validate and save your integration:
...
Configuring your Redshift account Account as a data destinationData Destination
Configuring your SAP DWC account as a data destination
Configuring your Snowflake account as a data destination
...