Blog
How AI Decision-Making is Improving Enterprise Outcomes
One of the highlights of Alteryx is Data Connections. It can be relied upon to generate and handle your data connections from a central location. The user can access it using their username and password.
The main advantages of Alteryx that set it apart :
- • data connectivity is high
- • direct access to the data sources/ bases
With the help of the Manage Data Connections window, it is possible to:
- • view connections you have already created
- • view connections shared with you
- • add new connections.
3 Steps to Create and Manage Your Data Connections with Alteryx
- Adding
- Testing
- Sharing
1. To Add a Data Connection
If the user wants to add a data connection, select Add New Data Connection on the Data Connections page. Then from the Connection drop-down select the connection type.
2. Testing Data Connections
The second step is to test the data connections. A controller and two or more worker machines make up a multi-node setup of the Server. With this arrangement, the test functionality examines the connection on the controller machine rather than the individual worker computers. One should verify the identical database drivers and driver versions are installed on every system to make sure the connection will function on any of them. Connection Test FailuresThe connection tests can fail due to multiple reasons. The user can save data connections even though they have failed the connection test.
These are the most typical causes of connection tests failing:
- • The server and database can be inaccessible to you in some circumstances. For instance, only the connection end user can access the server or database in certain cases.
- • Your ability to connect to the server or database may also be blocked by network security.
- • Sometimes the server is unable to connect to the host of the database server. At that time ping the database server host while logged into the server where Server is installed to check for network connectivity. The credentials for the database are incorrect or do not have the necessary access permissions. Get in touch with the database manager.
- • The database is unavailable. To ensure that the database is operational and performing as expected, get in touch with the database administrator.
- • The Server configuration you are using has several nodes.
3. To Share a Data Connection
After creating a Data Connection, go back to the Data Connections page to share it with users or custom groups for use in Designer.Note: Keep in mind that you must connect with a Curator or the gallery administrator to make sure that they have access to the necessary data connections if you want to allow the workflow to be used by particular users or groups.
Follow the steps mentioned below to share a Data Connection:
- • Choose the shareable data connection by clicking the pencil icon on the Data Connections screen.
- • Select Users or Custom Groups on the Modify Data Connections screen.
- • Enter a user's or a group's name here.
- • Choose the user or the group.
Note: Verify that the user's machine is installed with the same or a more recent version of the Microsoft SQL Server Native Client before initiating a Microsoft SQL Server connection. Go over to Troubleshooting.
a. Cancelling Access to a Data Connection
Choose the "x" icon next to a user's name to remove their access to a connection.
b. Modify a Data Connection
- 1. Choose the pencil icon on the Data Connections page.
- 2. Alter the Name or Connection String fields on the Modify Data Connections screen.
- 3. You can share the connection with people and groups using the Users or Custom Groups pages.
- 4. Choose Save.
1. Choose the trash can icon next to the connection name to remove the connection.
Tools in Alteryx Designer
Let’s have a look at the input tools available in Alteryx Designer:1. Input Data Tool
By connecting the Input Data tool to a file or database, you can utilise it to add data to your workflow. This tool has a wide range of configuration possibilities.2. Directory Tool

The Directory tool can be used to return a list of all the files present in the given directory. The tool returns file names along with additional details about each file, including file size, creation, and modification dates, and more.
3. Dynamic Input Tool

Using the Dynamic Input tool, it is possible to change file names, amend database queries, or alter input pathways that were created using data from your workflow are all possible If you're reading from a database, Alteryx will do it at runtime and will dynamically select which entries are read.
4. Connect In-DB Tool

When compared to conventional analysis techniques, the Connect In-Database tool can significantly enhance performance by allowing blending and analysis on large data sets without removing the data from the database.
Without proper tools, providing answers to business concerns would be time-consuming, laborious, hazardous, and possibly impossible. Here Alteryx can be of great help as it aids you to streamline operations, automate procedures, and provide predictive and geospatial solutions. While other technologies make the same claims, Alteryx is one of the incredible tools that empowers business users and analysts in addition to IT personnel.

Source:
So, whenever I open the workbook or the extract is refreshed, Tableau displays the unique values within the range specified, giving more control over the parameter values displayed.
Multiple Marks Layer Support for Maps
This is an exceptional feature to bring multiple spatial layers and context together to better understand and analyze geospatial data and map views. I will be able to include multiple marks layers from a data source to map visualizations and enhance the geospatial analysis. I can present more context in a single map view and perform further analysis with this feature.
Block Comments in Calculations
Block comments is a simple yet one of the most useful features for me, which Tableau has announced in 2020.4. I often used to add comments in complex calculations for easy understanding in future references. Earlier, only single-line comments were possible, limiting the description I could add. But from now on, I can add comments of any length to calculation windows with block comments by simply starting the comment with /* and ending with */.
What makes it unique is that the new multi-line block comment feature is consistent with other popular programming languages. This feature is an example of Tableau’s on-going effort to provide its customers with an intuitive user experience.
Tableau Server
Web Authoring Enhancements
Starting from Tableau 2020.4, it is possible to author dashboards from the browser just like how we design it in Tableau Desktop. With this web authoring enhancements, I can include Highlight actions, Format Mark Labels, apply filters to worksheets, create fixed sets, and even create extract in my workbooks from the browser itself. I no longer have to make changes from Tableau Desktop and publish it to the server. I can directly do it from the browser itself.
Offline Map Support for Tableau Server
Rendering dashboards with maps is now faster compared to previous versions. Now, I can create maps using the offline map style in web authoring, ensuring the performance of map views in Tableau Server. Offline map support is a great deal for organizations with strict internet access restrictions, assuring that map view access to all its users.
Tableau Server Management (TSM) Improvements
Tableau Server Administration activities like installation, upgrade and backup are now easy like never before. I can retry installation or upgrade from the last checkpoint in case of an unexpected issue or error during installation or upgrade, saving my efforts to obliterate tableau server.
Backups can be performed twice as fast as previous versions, and I can monitor the progress with the new progress bar giving visibility into what step the backup is on and how much time is remaining.
Backups can also be scheduled using TSM command starting from 2020.4 and that is awesome. I no longer need to prepare batch script and depend on the windows task scheduler to schedule the backups on regular intervals; instead, I can schedule it with just a single command.
Multiple Key Activation on Tableau Server Prior to TSM Initialization
During Tableau Server installation, it is now possible to activate multiple license keys prior to TSM initialization. I will be able to save a lot of time by eliminating the need to restart after the installation is completed to activate multiple licenses and experience a smoother installation.
Analytics Extension for Tableau Online
The power of the Analytics extension is now unlocked in Tableau Online too. The feature was already available in Tableau Server, and it helped us dynamically perform advanced analysis with models and functions in R, Python and other platforms.
Analytics extension in Tableau Online significantly enhances the scope of using Advanced Analytics by the common users.
Merge Duplicate External Assets
Earlier, the Database or Table with similar names used to appear as multiple assets within Tableau Catalog. But, the new feature helps me to merge those multiple assets into a single one. I can manage assets easily and keep an organized view of External assets by merging the common ones.
Tableau Prep
Tableau Prep Builder in the Browser
Prepare the data for visualizations from anywhere using a browser! Starting from 2020.4, Tableau is bringing the data prep process into one integrated platform on the web. Now I can easily prepare and manage prep flows from anywhere using a browser.
Conclusion
Tableau is progressively evolving as a single platform for data preparations, visualization, and collaboration with every update and version release.
Author : Firdous Maqbool
Images Courtesy : Tableau
Image source: