Importing Data from Local Databases

     

    ManageEngine Analytics Plus Upload Tool is a downloadable standalone utility, that enables you to upload data from huge CSV files and your local databases behind firewall into ManageEngine Analytics Plus. You can connect and upload data from Relational databases into ManageEngine Analytics Plus.

    You can upload data from any of the following data source.

    1. Upload Data from Large CSV Files

      You can bulk upload data in a CSV file format into ManageEngine Analytics Plus using this tool. It is especially useful when you need to upload more than 500,000 rows or whose file size is greater than 50 MB (these size limitation is applicable when you use the ManageEngine Analytics Plus Import wizard). This tool splits the data in the CSV file into batches and uploads it to ManageEngine Analytics Plus, making it much more resilient to intermittent Internet connectivity outages or slow connections. It can be invoked in GUI and Console (command line) modes.

    2. Upload Data from Relational Databases

      You can pull data from relational database and upload the same into ManageEngine Analytics Plus. You can connect to the databases like MS Access, MS Access 2010, MySQL, Microsoft SQL Server, Sybase, PostgreSQL, Oracle, SQLite, DB2, DB2-AS/400, Firebird or any JDBC driver supported database.

    Install and Setup the tool in your local machine to pull data from any of the above said source. The tool directly accesses your database, queries for the required data and uploads it to ManageEngine Analytics Plus. You can also setup automatic execution of the tool in a scheduled interval and keep the data synchronized with ManageEngine Analytics Plus.

     

    In the subsequent sections of this topic, we will discuss in detail about how to use the Upload tool in various modes to upload/synchronize your data with ManageEngine Analytics Plus.

    • Download and Setup

    • Uploading Data from CSV Files - GUI Mode

    • Uploading Data from CSV Files - Console Mode

    • Uploading Data from Relational databases

     

    Copyright © 2016, ZOHO Corp. All Rights Reserved.