• Anatella Quick User’s guide v3.05
  • 1. Introduction
    • 1.1. General Data Manipulation Features
    • 1.2 Development Functionalities
    • 1.3 Predictive Modeling Functionalities
  • 2. Anatella Installation
  • 3. How to run Anatella?
  • 4. How to use Anatella?
    • 4.1. A first example
      • 4.1.1. About the “Data-Preview” window
    • 4.2. Anatella Actions
      • 4.2.1. Input / Output Specifications
      • 4.2.2. Computing speed of the Action
      • 4.2.3. Breakpoints
      • 4.2.4. Actions being edited
      • 4.2.5. The Output pin being inspected
      • 4.2.6. Hard Drive Cache / Gel Files
      • 4.2.7. Action Status (OK/Error/Warning)
    • 4.3. A second example
    • 4.4. Execution of Anatella-Graphs
      • 4.4.1. Execution of Anatella-Graphs: The “Global Run Flag  Action”
      • 4.4.2. Execution of Anatella-Graphs: The “Run Mode ”
    • 4.5. Working with the HD cache
      • 4.5.1. Selecting the directory containing the “HD cache” / “Gel files”.
        • 4.5.1.1. Changing the default value for the “Working directory for cache files” parameter
      • 4.5.2. Manual creation of “HD cache”/ “Gel files”
      • 4.5.3. Forcing the automatic creation of a “HD cache”/ “Gel files” at each run
      • 4.5.4. Automatic deletion of “HD cache”/“Gel files”
      • 4.5.5. Manual deletion of “HD cache”/ “Gel files”
      • 4.5.6. Cleaning-up old and un-used “HD cache”/ “Gel files”
    • 4.6. Working with Anatella-Graphs
      • 4.6.1. Graph annotations
      • 4.6.2. Duplicating Actions
      • 4.6.3. Security – User management system – Graph Encryption
        • 4.6.3.1. Why encrypt .anatella graphs?
        • 4.6.3.2. Bulk Encryption of a large quantity of Anatella Files
    • 4.7. Batch Execution / Anatella command-line
      • 4.7.1. Re-Defining “Anatella Global Variables” on the command-line
      • 4.7.2. Defining Login and Password
      • 4.7.3. Silent mode & Quiet mode
      • 4.7.4. Generating Trace (log) files
      • 4.7.5. Changing the “Working directory for Cache Files” parameter
      • 4.7.6. Clearing the default value of all the “Anatella Global Variables”
    • 4.8. Scheduling Anatella Graphs
      • 4.8.1. Why Jenkins?
      • 4.8.2. Installing Jenkins
      • 4.8.3. Solving Jenkins Installation Errors
        • 4.8.3.1. Allow your “Windows User/Account” to execute as a service
        • 4.8.3.2. Running Jenkins as the LocalSystem Account
        • 4.8.3.3. Diagnostic Jenkins Errors (e.g. port 8080 is already in use)
      • 4.8.4. Scheduling your first Anatella graph with Jenkins
      • 4.8.5. Testing your scheduled Graphs
      • 4.8.6. Defining when your graphs are running (CRON string)
      • 4.8.7. Backing up Jenkins
      • 4.8.8. Configuring Jenkins to send email notifications in case of errors
        • 4.8.8.1. Configuration of the SMTP server used by Jenkins
        • 4.8.8.2. Per-Job configuration
      • 4.8.9. Configuring the Jenkins Execution Queue
      • 4.8.10. Using the Microsoft Windows Task Scheduler with Anatella
    • 4.9. Running an Anatella graph from another language (i.e. from Python, Jenkins, Php, Perl, etc.)
      • 4.9.1. Deprecated Solution (you can disregard this whole section)
    • 4.10. Linux Support: Running an Anatella graph in Linux
  • 5. Detailed description of the Actions
    • 5.1. General Parameters used in many actions
      • 5.1.1. Filenames
      • 5.1.2. Data Types
      • 5.1.3. Dates
      • 5.1.4. Column Chooser
      • 5.1.5. Graph Global Parameters
      • 5.1.6. ODBC Connections
        • 5.1.6.1. Type 1 ODBC connection: Create&Use an ODBC connection that was defined using the MS-Windows ODBC Manager
        • 5.1.6.2. Type 2 ODBC connection: Create&Use an ODBC connection based on a Connection-String
        • 5.1.6.3. Teradata ODBC setup
        • 5.1.6.4. Oracle ODBC Setup
        • 5.1.6.5. Sybase ODBC Setup
        • 5.1.6.6. My SQL ODBC Setup
        • 5.1.6.7. IBM DB2 Setup
          • 5.1.6.7.1. ODBC Driver installation
          • 5.1.6.7.2. ODBC Driver Configuration to create a Type 1 ODBC connection to DB2
          • 5.1.6.7.3. DB2 Unicode Character Support
        • 5.1.6.8. Microsoft SQL Server
        • 5.1.6.9. PostGre SQL Setup
        • 5.1.6.10. MS-Access Setup
        • 5.1.6.11. RedShift Setup
      • 5.1.7. OleDB connections
        • 5.1.7.1. Microsoft SQL Server OleDB Setup
        • 5.1.7.2. Oracle OleDB Setup
      • 5.1.8. Composite Primary Keys
      • 5.1.9. Internet access
        • 5.1.9.1. List of cURL error codes and their explanation
        • 5.1.9.2. Internet access through a PROXY
    • 5.2. Input Actions
      • 5.2.1. CSV file reader
        • 5.2.1.1. Reading corrupted CSV/Text files.
      • 5.2.2. Generic ODBC reader
      • 5.2.3. Generic OleDB reader
      • 5.2.4. SQLite Reader – GIS support
        • 5.2.4.1. GIS Support
      • 5.2.5. In-Line table
      • 5.2.6. Anatella “Gel” file reader (row-based Storage)
        • 5.2.6.1. Reading files with the “complete” meta-data-flag set to false.
        • 5.2.6.2. About asynchronous (and synchronous) I/O algorithms
        • 5.2.6.3. Reading Corrupted “.gel_anatella” files
      • 5.2.7. Anatella “Columnar Gel” file reader (column-based storage)
      • 5.2.8. SAS (.sas7bdat), SPSS (.sav and .por) and STATA (.dta) File Reader
      • 5.2.9. Excel File Reader
      • 5.2.10. XML/HTML File Reader
        • 5.2.10.1. HTML Extraction – A Simple Example
        • 5.2.10.2. HTML Extraction – A More Complex Example
      • 5.2.11. JSON File Reader
      • 5.2.12. Edi-Fact / X12 Reader
        • 5.2.12.1. Background information about EDI/X12 files
        • 5.2.12.2. Extacting Data from EDI/X12 files with Anatella
        • 5.2.12.3. Character Encoding in EDI/X12 files
      • 5.2.13. Query SMS Delivery Status
      • 5.2.14. Read Excel Sheets Names
      • 5.2.15. Merge Sort Input
      • 5.2.16. (old) SAS file reader
      • 5.2.17. Square File Reader
        • 5.2.17.1. Importing simple text files
        • 5.2.17.2. Importing COBOL-generated MainFrame files
      • 5.2.18. TCP-IP Receive table
      • 5.2.19. Rosette
      • 5.2.20. MQTT Subscribe (IoT connector)
      • 5.2.21. MQTT Unsubscribe (IoT connector)
      • 5.2.22. Join Input
      • 5.2.23. Read QVX
      • 5.2.24. Outlook Get
        • 5.2.24.1 About Outlook Profiles
        • 5.2.24.2. Outlook Synchronization
        • 5.2.24.3. Using the correct 32-bit or 64-bit Anatella version
        • 5.2.24.4. About the “MailTextBody” output column
        • 5.2.24.5. Importing large PST files in Anatella
      • 5.2.25. Read SAP tables
      • 5.2.26. Oracle OCI Connector
      • 5.2.27. Tableau .hyper File Reader
      • 5.2.28. Get Emails
      • 5.2.29. Read .yxdb Alteryx file
      • 5.2.30. Read XDF file
      • 5.2.31. Extract Data from Cryptographic Certificates
      • 5.2.32. Read Sheets Metadata from Excel files
      • 5.2.33. Read the Old Excel File format
    • 5.3. Run Control
      • 5.3.1. Run to finish Line
      • 5.3.2. Multithread Run
        • 5.3.2.1. Defining Multithread Sections
        • 5.3.2.2. Balancing Workload in different Multithread Sections
        • 5.3.2.3. Input Actions and Multithread Sections
        • 5.3.2.4. Limitations of N-Way Multithread Sections
        • 5.3.2.5. Overcoming the Limitations of N-Way Multithread Sections
        • 5.3.2.6. Thread Synchronization
        • 5.3.2.7. Main RAM Memory Consumption
        • 5.3.2.8. Fine-Tuning your script for Best Multithread Speed
        • 5.3.2.9. About multithreading inside other ETL’s
        • 5.3.2.10. Summary
      • 5.3.3. Parallel Run
      • 5.3.4. Row Counter
    • 5.4. Join Tables
      • 5.4.1. Append (High-Speed action)
      • 5.4.2. Join (High-Speed action)
      • 5.4.3. Multi Join (High-Speed action)
      • 5.4.4. Filter On Key (High-Speed action)
      • 5.4.5. Collate
      • 5.4.6. Merge CDRs
      • 5.4.7 Interval Join (High-Speed action)
      • 5.4.8 Fuzzy Join (JavaScript action)
      • 5.4.9. In-Memory Join (High-Speed action)
      • 5.4.10. GIS Join (High-Speed action)
    • 5.5. Standard
      • 5.5.1. Change Data Type (High-Speed action)
        • 5.5.1.1. Converting to (& checking) floating-point numbers
        • 5.5.1.2. Converting to (& checking) dates
        • 5.5.1.3. Converting Numbers to Strings
        • 5.1.1.4. Dynamically changing the Data Type
      • 5.5.2. Sort (High-Speed action)
        • 5.5.2.1. What are tapes? What is “Merge Sort”?
        • 5.5.2.2. Faster Alternatives to the “simple” Sort
        • 5.5.2.3. Sorting big data
        • 5.5.2.4. Managing RAM memory 1.
        • 5.5.2.5. Managing RAM memory 2.
        • 5.5.2.6. Managing RAM memory 3.
      • 5.5.3. Partitioned Sort (High-Speed action)
      • 5.5.4. Merge Sort (High-Speed action)
      • 5.5.5. Aggregate (Group by) (High-Speed action)
        • 5.5.5.1. Using the “in-memory mode” to compute several aggregations simultaneously
        • 5.5.5.2. Optimizing the sort before the “out-of-memory” Aggregate
        • 5.5.5.3. Using the “out-of-memory mode” inside a N-Way Multithreaded Section
        • 5.5.5.4. Avoiding a costly “sort”
        • 5.5.5.5. Dynamic Aggregation
      • 5.5.6. Calculator (High-Speed action)
        • 5.5.6.1. Manipulating Dates-stored-as-Key.
        • 5.5.6.2. Handling NULL Values
        • 5.5.6.4. Computing many columns
        • 5.5.6.5. Debugging complex expressions
        • 5.5.6.6. Updating columns
      • 5.5.7. Filter Rows (High-Speed action)
      • 5.5.8. Column filter (High-Speed action)
      • 5.5.9. Flatten (High-Speed action)
      • 5.5.10. Unflatten (High-Speed action)
      • 5.5.11. Insert Key (High-Speed action)
      • 5.5.12. Replace String (High-Speed action)
      • 5.5.13. Column Rename (High-Speed action)
      • 5.5.14. Get Meta-Data
      • 5.5.15. Sampling
    • 5.6. Cleaning
      • 5.6.1. Naïve Deduplicate (High-Speed action)
      • 5.6.2. Regular Expression Test (High-Speed action)
      • 5.6.3. Table validate
      • 5.6.4. Keep Only Duplicates
      • 5.6.5. Drop First Rows
      • 5.6.6. Pattern Extractor
      • 5.6.7. Discretize Variables
      • 5.6.8. Accumulator
    • 5.7. Data Mining
      • 5.7.1. TIMi Use Models (High-Speed action)
      • 5.7.2. Confusion Matrix (High-Speed action)
      • 5.7.3. Lift Curves (High-Speed action)
      • 5.7.4. Segmentation Model
      • 5.7.5. Transaction-level to Customer-level Aggregation
      • 5.7.6. Logarithm
      • 5.7.7. Compute RSquare
      • 5.7.8. Normalize
      • 5.7.9. Quantile (High-Speed action)
      • 5.7.10. Vectorized Calculator (High-Speed action)
      • 5.7.11. Covariance (High-Speed action)
    • 5.8. Graph Mining
    • 5.9. Text Mining
      • 5.9.1. Correct Spelling (High-Speed action)
        • 5.9.1.1. Mode 1: No reference Table
        • 5.9.1.2. Mode 2: We have a reference Table
        • 5.9.1.3. Which “Similarity Measure” do I use?
        • 5.9.1.4. How to use the results?
      • 5.9.2. Phonetic Encoding (High-Speed action)
      • 5.9.3. Detect Language (High-Speed action)
      • 5.9.4. Bag of Word (High-Speed action)
      • 5.9.5. E-Mails From Files
      • 5.9.6. Cloud of words
      • 5.9.7. Google Translate (High-Speed action)
      • 5.9.8. Read One File per Cell
      • 5.9.9. Write One File per Cell
      • 5.9.10. Extract Surrounding Lines
      • 5.9.11. Text Similarity
    • 5.10. TA - GIS - Geographical Information System
      • 5.10.1. KNN (High-Speed action)
      • 5.10.2. Geocode using Nominatim
        • 5.10.2.1. Building your own Nominatim Server
      • 5.10.3. Reverse Geocode using Nominatim
      • 5.10.4. Geocode Addresses using Bing
        • 5.10.4.1. How to get your BING Map Key.
      • 5.10.5. Compute the Traveling-time using Bing
      • 5.10.6. Compute Isochrones using Bing
      • 5.10.7. Geocoding & Reverse Geocoding
      • 5.10.8. Load Shape
      • 5.10.9. Save and view Shapes
        • 5.10.9.1. HTML visualization
        • 5.10.9.2. Quick SHP visualization
        • 5.10.9.3. SHP + QGIS visualization
      • 5.10.10. Reproject GIS
        • 5.10.10.1. A good, working example
        • 5.10.10.2. SRID and Storage Formats
        • 5.10.10.3. How to select a good SRID/Coordinate system?
      • 5.10.11. Geometry Info
      • 5.10.12. Simplify GIS
      • 5.10.13. Tesselate GIS
      • 5.10.14. ConcaveHull GIS
      • 5.10.15. Expand GIS
      • 5.10.16. Convert GIS
      • 5.10.17. Create GIS Grid
    • 5.11. TA - R Visualization
      • 5.11.1. Histogram (R action)
      • 5.11.2. Aggregate & Histogram (R action)
      • 5.11.3. Scatter Plot (R action)
      • 5.11.4. Correlation Matrix (R action)
      • 5.11.5. Correlation Matrix V2 (R action)
      • 5.11.6. Self Organizing Maps for data visualization (R action)
      • 5.11.7. A priori (R action)
      • 5.11.8. Cloud of Words (R action)
      • 5.11.9. Multi Dimensional Scaling (R action)
      • 5.11.10. Correspondance Analysis (R action)
      • 5.11.11. Waterfall Plot (R action)
      • 5.11.12. Multiplot (R action)
      • 5.11.13. Population Pyramid Plot (R action)
      • 5.11.14. ROC Curve (R action)
      • 5.11.15. KS Curve (R action)
      • 5.11.16. Box Plot (R action)
      • 5.11.17. Pie Chart (R action)
      • 5.11.18. Plot Time Series (R action)
    • 5.12. TA - R Predictive
      • 5.12.1. Multivariate Outlier Detection (R action)
      • 5.12.2. CART – Step 1 - Create one “deep” tree (R action)
      • 5.12.3. CART – Step 2- Prune a “deep” tree (R action)
      • 5.12.4. Neural Network & MultiNomial Logistic Prediction (R action)
      • 5.12.5. Support Vector Machine (R action)
      • 5.12.6. Naïve Bayes (R action)
      • 5.12.7. XGBoost (R action)
      • 5.12.8. Time Series (R action)
      • 5.12.9. GLM (R action)
      • 5.12.10. CHAID (R action)
      • 5.12.11. Cox Model (R action)
      • 5.12.12. Interactive CART (R action)
      • 5.12.13. C50  (R action)
    • 5.13. TA - R_Discovery Analytics
      • 5.13.1. PCA (R action)
      • 5.13.2. Hierarchical Clustering (R action)
      • 5.13.3. K-Means Clustering (R action)
      • 5.13.4. K-Medoids Clustering (R action)
      • 5.13.5. Model Clustering (R action)
      • 5.13.6. Latent Class Analysis Clustering (R action)
      • 5.13.7. DBSCAN Clustering (R action)
      • 5.13.8. Bayesian Network (R action)
      • 5.13.9. Cross Tabulation (R action)
    • 5.14. TA - R Scoring
      • 5.14.1. Apply a R-Based predictive model (R action)
      • 5.14.2. Apply a R-Based PCA model (R action)
      • 5.14.3. Apply a R-Based Segmentation model (R action)
    • 5.15. TA - Python Various
      • 5.15.1. PyLoad Excel File (Python action)
      • 5.15.2. Multiclass Logistic Regression (Python action)
      • 5.15.3. PyApply Model (Python action)
      • 5.15.4. PyApply Timi Model (Python action)
      • 5.15.5. Read Pickle (Python action)
      • 5.15.6. Write Pickle (Python action)
    • 5.16. TA - Operational Research
      • 5.16.1. Assignment Solver (High-Speed action)
      • 5.16.2. Dataset Reduction (High-Speed action)
    • 5.17. TA - Time Series
      • 5.17.1. Aggregate on Columns (High-Speed action)
      • 5.17.2. Smoothen rows (High-Speed action)
      • 5.17.3. Sum on Rows
      • 5.17.4. Time travel
    • 5.18. TA - Stats
      • 5.18.1. Student T-test
      • 5.18.2. Stratified Sampling
      • 5.18.3. Line Regression
    • 5.19. TA - Formatters
      • 5.19.1. Concat
      • 5.19.2. Date/Time Formatter
      • 5.19.3. Number Formatter
      • 5.19.4. Split
      • 5.19.5. CRC
      • 5.19.6. Distribute
      • 5.19.7. ReadPDF
      • 5.19.8. wordExportation to PDF
      • 5.19.9. Excel Exportation to PDF
      • 5.19.10. Powerpoint Exportation to PDF
      • 5.19.11. Convert between TimeZones
      • 5.19.12. Square Split
      • 5.19.13. Transform Birthday to Age
    • 5.20. TA - Key Performance Indicators
      • 5.20.1. Rank by Partition
      • 5.20.2. Rolling Sum on Dates
      • 5.20.3. Value Back in Time
      • 5.20.4. KPI
    • 5.21. TA - System Tools
      • 5.21.1. Abort a Graph
      • 5.21.2. Clean HD Cache Temp Dir
      • 5.21.3. Run Processes
      • 5.21.4. List Files
      • 5.21.5. Loop Anatella Graphs
      • 5.21.6. Loop Anatella Graphs Advanced
      • 5.21.7. Upgrade to XLSX
      • 5.21.8. Downgrade to XLS
      • 5.21.9. Reorder Files per Day
      • 5.21.10. Run Selected Pin
      • 5.21.11. Lock Graph Execution to some given Servers
    • 5.22. TA - Distributed Computations
      • 5.22.1. Loop with Jenkins
        • 5.22.1.1. First Time Jenkins Configuration required before using the  “Loop Jenkins” action.
        • 5.22.1.2. (optional) Configure the Jenkins execution Queue
      • 5.22.2. Wait for the termination of Jenkins Jobs
      • 5.22.3. Query Jenkins
    • 5.23. Cloud services
      • 5.23.1. Down and Uploads
      • 5.23.2. Multiple Down and Uploads
        • 5.23.2.1. Downloading files with unknown filenames
      • 5.23.3. Calling a generic REST api
      • 5.23.4. Check VAT
      • 5.23.5. Publish to Tableau Server
        • 5.23.5.1. How to get a Personal Access Token (PAT) ?
        • 5.23.5.2. Limitations linked to Personal Access Token (PAT)
        • 5.23.5.3. Benefits linked to the use of Personal Access Token (PAT)
      • 5.23.6. List the Files inside a S3 bucket 
      • 5.23.7. List S3 buckets
      • 5.23.8. Download Files from a S3 bucket
      • 5.23.9. Upload Files to a S3 bucket
      • 5.23.10. Delete Files stored in a S3 bucket
      • 5.23.11. Unlock Google Services
      • 5.23.12. List the files on a GDrive
      • 5.23.13. Download files from a GDrive 
        • 5.23.13.1. Synchronizing all local files from a source Google Drive
        • 5.23.13.2. Download the responses to a Survey made with Google Forms
      • 5.23.14. Upload local files to a GDrive
      • 5.23.15. Delete files stored on a GDrive
      • 5.23.16. List the files on a Google Cloud Storage
      • 5.23.17. Download files from a Google Cloud Storage
      • 5.23.18. Upload files to a Google Cloud Storage
      • 5.23.19. Delete files from a Google Cloud Storage
      • 5.23.20. List the buckets on a Google Cloud Storage
      • 5.23.21. Download/Query a table on Google Big Query
      • 5.23.22. Upload a table to Google BigQuery
      • 5.23.23. Google Analytics
      • 5.23.24. Facebook
        • 5.23.24.1. Facebook Action: First time setup
        • 5.23.24.2. How to get the Facebook PageID’s?
      • 5.23.25. SalesForce Download
        • 5.23.25.1. Salesforce Download/Upload: First time setup
        • 5.23.25.2. Troubleshooting the Salesforce connection
      • 5.23.26. SalesForce Upload
      • 5.23.27. Unlock Azure services
        • 5.23.27.1. Securing access to your Azure account
      • 5.23.28. SharePoint Download
      • 5.23.29. SharePoint Upload
      • 5.23.30. Azure Storage List Files
        • 5.23.30.1. Azure Storage first time setup
      • 5.23.31. Azure Storage Download Files
      • 5.23.32. Azure Storage Upload Files
      • 5.23.33. Azure Storage Delete Files
      • 5.23.34. Azure Storage List Containers
      • 5.23.35. OneDrive List Files
      • 5.23.36. OneDrive Download Files
      • 5.23.37. OneDrive Upload Files
      • 5.23.38. OneDrive Delete Files
      • 5.23.39. Huawei Blob Storage List Files
        • 5.23.39.1. Huawei Blob Storage First Time Setup
      • 5.23.40. Huawei Blob Storage Download Files
      • 5.23.41. Huawei Blob Storage Upload Files
      • 5.23.42. Huawei Blob Storage Delete Files
      • 5.23.43. Huawei Blob Storage List Buckets
      • 5.23.44. Unlocks ZohoCRM
      • 5.23.45. Download data from Zoho CRM
      • 5.23.46. Twitter
        • 5.23.46.1. Twitter first time setup
      • 5.23.47. DeepL automated translation
        • 5.23.47.1. DeepL first time setup
      • 5.23.48. Google Speech-to-Text
      • 5.23.49. Text Razor Topic Extraction
        • 5.23.49.1. TextRazor first time setup
      • 5.23.50. Unicheck plagiarism checker
        • 5.23.50.1. Unicheck first time setup
      • 5.23.51. UI Path List
        • 5.23.51.1. UIPath first time setup
      • 5.23.52. UI Path Run Processes
      • 5.23.53. Get Emails using your Office 365 subscription
      • 5.23.54. Send Emails using your Office 365 subscription
      • 5.23.55. Download data from Odoo
        • 5.23.55.1. Odoo first time setup
      • 5.23.56. Upload data to Odoo
      • 5.23.57. Get data from Microsoft Dynamics CRM
      • 5.23.58. Send data to Microsoft Dynamics CRM
      • 5.23.59. OVH Cloud Object Storage List Files
        • 5.23.59.1. OVH Cloud Storage particularities
        • 5.23.59.2. OVH Cloud Storage first time setup
      • 5.23.60. OVH Cloud Object Storage Download Files
      • 5.23.61. OVH Cloud Object Storage Upload Files
      • 5.23.62. OVH Cloud Object Storage Delete Files
      • 5.23.63. OVH Cloud Object Storage List Containers
      • 5.23.64. Get Emails from GMail
      • 5.23.65. Send Emails using GMail
      • 5.23.66. Download JSON documents from Elastic Search
      • 5.23.67. Upload JSON documents to Elastic Search
      • 5.23.68. Delete JSON documents from an Elastic Search Server
      • 5.23.69. List all the Indexes on an Elastic Search Server
      • 5.23.70. List the Files on a Mailbox.org drive
      • 5.23.71. Download Files from a Mailbox.org drive
      • 5.23.72. Upload Files to a Mailbox.org drive
      • 5.23.73. Delete Files on a Mailbox.org drive
      • 5.23.74. Download logs from a Splunk Server
      • 5.23.75. Upload logs to a Splunk Server
      • 5.23.76. Download JSON from a MongoDB Server
      • 5.23.77. Upload JSON documents to a MongoDB Server
      • 5.23.78. Download data from a Neo4J server
      • 5.23.79. List ressources on a Jira server
        • 5.23.79.1. How to get your Jira Token?
      • 5.23.80. Retrieve the results of a JQL query running on a Jira server
      • 5.23.81. List jobs in Jenkins
      • 5.23.82. Download logs from Jenkins
      • 5.23.83. Download data from SuiteCRM
        • 5.23.83.1. SuiteCRM First time setup
      • 5.23.84. Upload data to SuiteCRM
      • 5.23.85. Delete data on a SuiteCRM server
      • 5.23.86. Get Data from Supermetrics
      • 5.23.87. Google Ads
      • 5.23.88. List Surveys from Survey Monkey
        • 5.23.88.1. Survey Monkey First Time setup
      • 5.23.89. Download Responses from Survey Monkey
      • 5.23.90. PowerBI Upload
        • 5.23.90.1. PowerBI first time setup
      • 5.23.91. Download from Hubspot
      • 5.23.92. Upload data to Hubspot
      • 5.23.93. DropBox unlock
      • 5.23.94. Dropbox List Files
      • 5.23.95. Dropbox Download Files
      • 5.23.96. Dropbox Upload Files
      • 5.23.97. Dropbox Delete Files
      • 5.23.98. Azure Manage Contacts
      • 5.23.99. PhantomBuster Extraction
      • 5.23.100. DropContact Extraction
      • 5.23.101. Bouncer Validation
      • 5.23.102. ChatGPT query
    • 5.24. TA - Data Engineering
      • 5.24.1. Historized Slowly Changing Dimensions
      • 5.24.2. RedShift Bulk Upload through a S3 Bucket
      • 5.24.3. SnowFlake Bulk Upload through an Azure Storage
      • 5.24.4. SnowFlake Bulk Upload through a S3 Bucket
    • 5.25. Other Transformations Actions (TA)
      • 5.25.1. Encrypt (High-Speed action)
      • 5.25.2. Transpose
      • 5.25.3. Extract New Column Names
      • 5.25.4. Column Names for DB
      • 5.25.5. File List from Observation Date
      • 5.25.6. Auto unflatten
    • 5.26. User-Deprecated Transformations
      • 5.26.1. Column Filter
      • 5.26.2. Template
      • 5.26.3. PyGoogle Analytics (Python action)
      • 5.26.4. Create old Tableau Hyper File (.hyper) or Tableau Data Extract (.tde) file 
    • 5.27. Output Actions
      • 5.27.1. CSV file writer
      • 5.27.2. Anatella “Gel file” writer
      • 5.27.3. Anatella “Columnar Gel” file writer (column based)
      • 5.27.4. Generic ODBC Writer
        • 5.27.4.1. Inserting Rows inside a Table with an INDEX
      • 5.27.5. Create Table
      • 5.27.6. SQLite Writer
      • 5.27.7. Send E-Mails
      • 5.27.8. Send SMS with SMPP protocol (to a SMSC server)
      • 5.27.9. Send SMS with HTTP protocol (to a SMS Gateway)
      • 5.27.10. MS-Office-Charts Report Writer
      • 5.27.11. Excel file Writer
      • 5.27.12. XML File Writer
      • 5.27.13. JSON File Writer
      • 5.27.14. TCP-IP Send table
      • 5.27.15. MQTT Publish (IoT connector)
      • 5.27.16. Create Tableau Hyper File (.hyper)
      • 5.27.17. Write Qlikview QVX
      • 5.27.18. Export To Kibella
      • 5.27.19. Teradata Writer
      • 5.27.20. Write in Docx and Pptx
        • 5.27.20.1. Example of processing for “Text Markers”
        • 5.27.20.2. MS-Word Template pre-processing.
        • 5.27.20.3. Insertion of “Image Markers” inside .docx and .pptx documents
        • 5.27.20.4. Example of processing for “Image Markers”
      • 5.27.21. Write Tables in Docx
      • 5.27.22. Outlook Send
      • 5.27.23. Generic OleDB writer
      • 5.27.24. Postgres Writer
      • 5.27.25. Oracle writer
  • 6. Hadoop Integration
    • 6.1. Introduction
    • 6.2. Examples of Hadoop Integration with Anatella
      • 6.2.1. Example 1: Browsing HDFS
      • 6.2.2. Example 2: Listing Files/Directories on HDFS
      • 6.2.3. Example 3: Copying Files from/to HDFS
    • 6.3. First time setup
    • 6.4. Finding the right Credential/Login
    • 6.4. Do I need an Hadoop HDFS drive?
    • 6.5. Expectations
  • 7. Anatella Global settings
    • 7.1. Panel 1: Default Temporary Directory for HD Cache Files
      • 7.1.1. Changing the value of the Global OS Temp Directory parameter
    • 7.2. Panel 1: .anatella files
      • 7.2.1. Character Encoding
      • 7.2.2. .anatella file Automatic Save
      • 7.2.3. Backup of Anatella files.
      • 7.2.4. Global locking mechanism
    • 7.3. Sound
    • 7.4. Panel 1: Serial Number
      • 7.4.1. Get your serial Number at the first execution of Anatella
      • 7.4.2. (re)Open the “Serial Number Manager” application
      • 7.4.3. Enter your License Informations (for the Current User Only)
      • 7.4.4. Enter a Server-Wide License
    • 7.5. Panel 1: Restart the Anatella server
    • 7.6. Panel 1: Anatella SQL Logging
    • 7.7. Panel 2: Javascript/R/Python Revision Control
  • 8. Anatella best practices
    • 8.1. One graph per Anatella window
    • 8.2. Run each graph inside its own window
    • 8.3. Quickly stop/abort a graph execution
    • 8.4. Avoid losing time when freezing
    • 8.5. Quickly close and re-open Anatella graphs
    • 8.6. Avoid “diamond shapes” in graphs
    • 8.7. Use sampling wisely
    • 8.8. Forcing the “Refresh from PIN” button to return some columns
    • 8.9. Collaborative Work
  • 9. Anatella for the Expert Users
    • 9.1. Developing new Script-Based Anatella Actions
      • 9.1.1. Selecting the Right Language to create your new Actions
      • 9.1.2. How to edit the Script-code of an Action?
    • 9.2. About the integration of Javascript, R, Python inside Anatella
      • 9.2.1. JavaScript Integration inside Anatella
        • 9.2.1.1. Example 1
        • 9.2.1.2. Example 2
        • 9.2.1.3. Example 3
        • 9.2.1.4. Example 4
        • 9.2.1.5. On the proper usage of the “rowDeepCopy()” function
          • 9.2.1.5.1.  Use Case 1
          • 9.2.1.5.2.  Use Case 2
      • 9.2.2. R Integration inside Anatella
        • 9.2.2.1. First Time Setup
        • 9.2.2.2. Coding in R inside Anatella
      • 9.2.3. Python Integration inside Anatella
        • 9.2.3.1. First Time Setup
        • 9.2.3.2. Coding in Python inside Anatella
    • 9.3. Defining script parameters
      • 9.3.1. The script parameter type “String”
      • 9.3.2. The script parameter type “Double”
      • 9.3.3. The script parameter type “Bool”
      • 9.3.4. The script parameter type “Combobox”
      • 9.3.5. The script parameter type “OneColumn”
      • 9.3.6. The script parameter type “ManyColumn”
      • 9.3.7. The script parameter type “OneFileSave”
      • 9.3.8. The script parameter type “OneFileOpen”
      • 9.3.9. The script parameter type “ManyFileOpen”
      • 9.3.10. The script parameter type “OneDir”
    • 9.4. Using script parameters
      • 9.4.1. Script Parameters From the “Script-Parameter-tab” of the Action-Property-Window
      • 9.4.2. Script Parameters From the “Graph Global Parameter” window (Javascript Actions only)
    • 9.5. Editing the Action descriptions
    • 9.6. The Configuration Tab
      • 9.6.1. Changing the pin configuration of a script-based Action
      • 9.6.2. Cast
      • 9.6.3. Embed icon inside an .anatella file
    • 9.7. Publishing, Maintaining and Sharing Script-Based Actions
      • 9.7.1. Creating New Script-Based Actions
      • 9.7.2. A Typical Workflow
    • 9.8. Anatella-Scripts automatic versioning
    • 9.9. Executing Scripts inside a N-Way Multithread section
      • 9.9.1. For JavaScript-based Actions
      • 9.9.2. For R/Python based Actions
    • 9.10. Debugging JavaScripts-based Actions
      • 9.10.1. Starting the debugger
        • 9.10.1.1. Managing break points
        • 9.10.1.2. Running an Anatella-Graph in “debug” mode
      • 9.10.2. Using the debugger
      • 9.10.3. Stopping the debugger
  • 10. FAQ
    • 10.1. Help! I can’t open my .anatella files anymore!?
      • 10.1.1. You need to update your Anatella software.
      • 10.1.2. Broken .anatella file or Broken TIMi file association.
      • 10.1.3. Encrypted .anatella file
    • 10.2. Help! I am seeing NaN everywhere!
    • 10.3. Help! I just made an error and I want to undo it!
    • 10.4. Anatella is accessing the computer network. Is it normal?
    • 10.5. I can’t find anymore the “Model Merger” module from TIMi?
    • 10.6. How to group several Actions into one unique Action?
    • 10.7. How to create “Loops” inside Anatella?
    • 10.8. Web Service, Real-time Data Streaming and Master Data Management
      • 10.8.1. Streaming data processing using an HTTP source/sink
      • 10.8.2. Streaming data processing using an IoT/MQTT source/sink
      • 10.8.3. General Purpose Web Service
      • 10.8.4. Limitations to the Real-Time Data Streaming in Anatella
    • 10.9. Where is the “open source” source code?
    • 10.10. Working with Databases
      • 10.10.1. Introduction: Use the right tool for the right job.
      • 10.10.2. Upload a fresh copy of a whole table
      • 10.10.3. About Bulk Upload Tools
      • 10.10.4. Securely adding rows to a database table
        • 10.10.4.1. Incremental Table Upload
        • 10.10.4.2. Secure Database Table Upload without Primary Key
      • 10.10.5. Saving Historical Data
        • 10.10.5.1. You have a column named “LAST_UPDATE_TIME”
        • 10.10.5.2. You have no column named “LAST_UPDATE_TIME” inside your database
    • 10.11. How to install both the 32-bit and the 64-bit versions of Anatella simultaneously?
    • 10.12. Automatic bulk change of ODBC connection parameters
  • 11. Appendix
    • 11.1. Appendix A: Introduction to the Standard JavaScript Language
    • 11.2. Appendix B: Advanced JavaScript tutorial.
    • 11.3. Appendix C: JavaScript popularity
    • 11.4. Appendix D: Is Anatella Fast?
    • 11.5. Appendix E: The standard functionalities offered by any JavaScript /ECMAScript compliant engine
    • 11.6. Appendix F: Anatella-specific JavaScript extensions