As with other instances, your data warehouses are added in the web interface.
To add a new data warehouse, follow the steps below.
The 'add' form is structured into three sections - we'll take them one by one in the following.
The first section is basic information that is - mostly - the same for all instance types.
- In the Name box, type the name you want to use for the data warehouse.
- In the Description box, type a description of the data warehouse. The description is displayed on the desktop and on the instance details page.
- (Optional) In the Log Retention Days box, adjust the number of days logs should be kept.
- (Optional) In the Team Development list, click Enabled if you want to allow multiple developers to access the instance at the same time.
SQL Server storage
The second section concerns connection information storage information.
- In the Server name box, type the name of the server that you want to store the database on. If it is a named instance, type the server name and the instance name.
- In the Server type list, select the type of the server. Currently, you'll only have to change this setting if you're using a dedicated SQL pool (previously known as SQL Data Warehouse).
- In the Database box, type the name of the database you want to use.
Note: The first time you open the data warehouse on the desktop, you need to right-click the data warehouse instance, click Edit Instance... and click Create Storage...
- In the Authentication list, click the mode of authentication you want to use. You have the following options:
- Windows Authentication: Use the logged-in Windows user's credentials for authentication.
- SQL Server Authentication: Use a login set up on the SQL Server. Enter the username and password in the corresponding fields.
- Azure AD Password Authentication: Use Azure AD credentials from a domain that is not federated with Azure AD. Enter the username and password in the corresponding fields.
- Azure AD Integrated Authentication: Use the logged-in Windows user's credentials for authentication, provided that he is logged in using Azure AD credentials from a domain that is federated with Azure AD.
- (Optional) In the Connection timeout box, enter the number of seconds to wait before terminating the attempt to connect to the server. Set it to 0 to wait indefinitely.
- (Optional) In the Command timeout box, enter the number of seconds to wait before terminating a command. Set it to 0 to wait indefinitely.
- In the Batch size box, enter the number of rows to copy when using ADO.net transfer. '0' equals unlimited.
- (Optional) In the Encrypt connection list, you can enable encryption of the connection, which is recommended when you are not in a private network (e.g. when your server is on Azure). You have the following options:
- No: The communication is not encrypted (default).
- Yes: The communication is encrypted. The server's certificate is verified by a certificate authority.
- Yes, trust server certificate: The communication is encrypted. but the server's certificate is not verified. This setting is not recommended for use on public networks.
- (Optional) If you need a connection string with properties not found in the UI, you can enter it in the Additional connection properties box. It will override the data in the other boxes with connection information.
Transfer from ODX
In the last section, you can set how data should be copied from ODX to the data warehouse storage.
- In the Technology list, click on the method you want to use for transferring data from the ODX to the data warehouse. The following settings are available:
- ADO.net: The application-native method.
- Azure Data Factory: Uses Azure Data Factory, which can be faster if the ODX data storage and data warehouse are both on Azure. If you select this, you'll then have to enter the connection information to the Azure Data Factory you want to use.
And that's it. Click Save to add your new data warehouse instance.
Note: TimeXtender Desktop must be refreshed to retrieve the newly created instance.
Edit a Data Warehouse Instance
1. Click on your instance, it will open a page with instance details
2. Click on Edit button, edit properties and Save
Delete a Data Warehouse Instance
1. Click on Delete button next to your instance. The Delete dialog will be shown.
Create Data Warehouse Storage
Before you can deploy and execute tables in a data area within a data warehouse instance, you must create the data storage. Right-click on the instance and select Edit Instance.