Export containers

Export containers organizes data distribution from a Profitbase Studio data warehouse solution.

Scripting capabilities allow for exporting data to a system of any type, but the integrated export types are:

- Azure SQL database table (via PowerShell)

- Csv file (via PowerShell)

- Csv file copied to Azure Blob Storage (via PowerShell)

- Csv file streamed to Azure Blob Storage (via .Net)

 

Fields - Azure SQL database table (via PowerShell)

Name	Azure SQL Database Alias Name
Server name	Full server name. I.e. tcp:servername.database.windows.net
Database name	Enter Azure SQL Database name
Schema	Schema. I.e. dbo
Username	Azure SQL Server login name.
Password	Azure SQL Server login password.
Timeout	Command and connection timeout in seconds.

 

Fields - Csv file (via PowerShell)

Folder	UNC path to files. Click 'Browse' to choose a UNC path.
Header row	Indicate if there are headers in the first row.
Column delimiter	What columns are delimited by.
Row Delimiter	What rows are delimited by.
Text qualifier	What text is qualified by.
Code page	The code page of the csv file.
Timeout	Command and connection timeout in seconds.

 

Fields - Csv file copied to Azure Blob Storage (via PowerShell)

Name	Azure Blob Storage Name.
Container	Azure Blob Storage Container.
Folder path	Azure Blob Storage folder path.
Source file path	UNC path to where files are to be uploaded from.
Timestamp pattern	Timestamp pattern used to avoid overwriting existing files in UNC path.
Key	Azure access key to azure blob storage.
Timeout	Command and connection timeout in seconds.

 

Fields - Csv file streamed to Azure Blob Storage (via .Net)

Name	Azure Blob Storage Name.
Container	Azure Blob Storage Container.
Folder path	Azure Blob Storage folder path.
Timestamp pattern	Timestamp pattern used to avoid overwriting existing files in UNC path.
Key	Azure access key to azure blob storage.
Timeout	Command and connection timeout in seconds.