Skip to content
Infoveave Help

Introducing Datasources

Datasources in the Infoveave Studio module serve as the foundation for data connectivity and integration. They enable you to establish a link to various external Datasources such as databases, cloud services and APIs. With a Datasource, you efficiently import, manage and manipulate data. This sets the stage for effective data analysis, visualization and reporting.

Infoveave Datasource Classification

Files

File-based Datasources in Infoveave offer a flexible way to connect with and manage various file formats. You can choose from multiple file types and structures that best suit your data needs.

  • Delimited Suitable for CSV, TSV, PSV, and custom delimited files.
  • Excel Supports both XLS and XLSX formats, allowing direct interaction with Microsoft Excel files.
  • Fixed length Separates data into columns using positional information. Ideal for working with structured datasets.
  • JSON Connects to JSON-based APIs and automations, ensuring seamless integration with JSON Datasources.
  • Multi file Lets you combine multiple file types within a single Datasource to simplify complex data configurations.
  • Plugin Parser Enables the upload of custom C# plugins to parse specific file formats and enhance data interpretation.

Databases

Infoveave offers a range of database options to store and manage data effectively. These databases are reliable, scalable, and designed to suit various enterprise requirements.

  • Apache Cassandra Offers decentralized storage for reliable and scalable data management.
  • MariaDB An open-source version of MySQL, ideal for enterprise-level database requirements.
  • Microsoft SQL A relational database solution from Microsoft that supports both on-premises and cloud environments.
  • MongoDB A NoSQL database designed for handling flexible and dynamic data.
  • MySQL Oracle’s widely used relational database management system for structured data.
  • Oracle An enterprise-grade solution available for both cloud and on-premises deployment.
  • Percona A MySQL variant that provides enhanced features for efficient data management.
  • Postgres An open-source database known for its adaptability across different environments.

Cloud Services

Seamless integration with popular cloud services allows you to boost your data analysis capabilities in Infoveave. You can select from the following supported services.

  • Amazon Athena A serverless analytics service from Amazon that enables easy querying of data.
  • Amazon Redshift A managed data warehouse that delivers scalable, high-performance analytics for large datasets.
  • Data World Helps you manage and explore your data catalog effectively in the modern data ecosystem.
  • Databricks Provides a SQL warehouse that lets you query and explore data on the Databricks platform.
  • Google Analytics A web analytics service offered by Google that tracks and reports website and app traffic. Infoveave seamlessly connects to Google Analytics V3 and V4, enabling you to gain insights from web analytics data.

Others

Infoveave also supports unique Datasource types that go beyond traditional integrations. These options provide additional flexibility for specialized data requirements.

  • Custom file parser Allows you to parse unstructured text files using custom code tailored to your specific format.
  • IOT Lets you create an IOT Datasource that listens to devices and captures real-time data streams for actionable insights.