Database Name

External Schema

External Table

Hostname

Node Command called without any node passed

SQL Server

Server Name

Service name / SID

Source Schema

Source Table

({0} KB)

Done downloading {0}

Downloading {0}

Failed to start {0}: {1}

Installed {0}

Installing {0}

Installing {0} to {1}

Starting {0}...

{0} started

View Known Issues

service component could not start

Process exited with code {0}

Database the external table will be created in

Destination Server

External data source for new external table

Name for new external table

Name for new table's external file format

No user schemas were found in the specified database.

No valid external data sources were found in the specified database.

Refresh

Schema for new external table

Source File

Source Folder

The specified external file format name already exists.

The specified table name already exists under the specified schema.

Allow Nulls

Column Name

Data Type

Failed to generate column information for the specified file.

Failed to retrieve any data from the specified file.

This operation analyzed the input file structure to generate the preview below for up to the first 50 rows.

Data Virtualization information

Database name

File format name

Server name

Source File

Source Folder

Table name

Table schema

Virtualize Data

Currently only csv files are supported for this wizard.

Modify Columns

No csv files were found in the specified folder.

Please select a source file or folder before using this wizard.

Preview Data

Select the destination database for your external table

Summary

The script has opened in a document window. You can view it once the wizard is closed.

Virtualize Data

Virtualize Data From CSV

-- Create New Credential --

Choose Credential

Configure Credential

Create a connection to your Data Source

External Data Source Name

New Credential Name

Password

Server Connection

The name for your External Data Source.

The name of the Database Scoped Credential used to securely store the login information for the External Data Source you are creating.

Username

A Master Key already exists for the selected database. No action is required on this page.

A master key is required. This secures the credentials used by an External Data Source. Note that you should back up the master key by using BACKUP MASTER KEY and store the backup in a secure, off-site location.

Confirm Password

Create Database Master Key

Password

Password values do not match.

Set the Master Key password.

Strong passwords use a combination of alphanumeric, upper, lower, and special characters.

Clicking on the checkbox will select that table to be mapped.

Clicking on the table name will show you the column mapping information for that table.

Collations

Column Mapping

External

Map your data source objects to your external table

No objects were selected.

No table information present for '{0}'

Nullable

SQL Data Type

Source

Tables

These column types are not supported for external tables:{0}{1}

Unsupported Column Types found

Views

A data source type must be selected.

A destination database must be selected.

Default

Select a Data Source

Select the destination database for your external table

Select your data source type

The database in which to create your External Data Source.

Database Master Key

Database Scoped Credential

Destination Database:

Executing script...

External Data Source

External Table

External Table creation completed successfully

External Table creation failed

Name

Object type

Schema

Summary

The following objects will be created in the destination database:

Virtualize Data

Create

The script has opened in a document window. You can view it once the wizard is closed.

Virtualize Data

Data Virtualization requires a connection to be selected.

Data Virtualization

Enable/disable logging debug information to the developer console.

Number of lines to read from a file to run PROSE parsing on.

Support for Data Virtualization features in SQL Server

Support for Data Virtualization in SQL Server, including wizards for creating an External Table from an External Data Source or CSV files.

Tasks

Virtualize Data

Virtualize Data From CSV Files