Python is a popular programming language that can be used for advanced analytics and data modeling. Dundas BI integrates with Python at the data cube level via two transforms, which you can use to supply data to the data cube or perform data processing/analysis on other data.
2. Install Python
When Dundas BI version 7 or above is installed on your own server, Python can be installed automatically in the prerequisites step of the installation process. If needed, you can begin creating a new instance to use this prerequisites step later even without completing the wizard.
If you need to install or re-install Python yourself on Windows manually, download and run the installer for the 64-bit version of Python on your Dundas BI server with the correct version number as listed in the system requirements for your version of Dundas BI. On Linux, the standard default version of python3 provided by the particular Linux distribution and version is used.
The process on Windows should be similar to the following:
Select Customize installation and click Next on the Optional Features page.
Select Install for all users on the Advanced Options page and click Install.
3. Install packages
Packages other than those installed automatically by Dundas BI must be installed by an administrator on the server that runs Dundas BI before they can be used in Python transforms.
For example, to install the common pandas package, which includes other packages such as NumPy:
- Open the command prompt or terminal on the Dundas BI server as an administrator (e.g., right-click on Command Prompt in the start menu and choose Run as administrator).
- You may need to navigate to the particular Scripts folder corresponding with the version of Python used by Dundas BI. For example:
cd C:\Program Files\Python38\Scripts
- Use pip to install the package. For example:
pip install pandas
- The Python-related transforms in Dundas BI require a result to be returned by the Python script, which can be represented as a table. This includes results generated using the NumPy and Pandas packages for data analysis.
- You may be required to restart the server after installing Python.