Documentation

Data Integration

Connecting Your Data to Fluxjiva

Fluxjiva offers flexible options for connecting your data. This guide explains the different methods available and how to use them effectively.

Why Data Integration Matters

Effective data integration is the foundation of successful analytics. With Fluxjiva's seamless integration capabilities, you can:

  • Analyze data from multiple sources in one place
  • Maintain data freshness with automated refreshes
  • Ensure data security with enterprise-grade protection
  • Scale your analytics as your data grows

Supported Data Sources

Fluxjiva supports a wide range of data sources to accommodate your existing data infrastructure:

File Uploads

  • CSV files
  • Excel (XLSX, XLS)
  • JSON files
  • XML files
  • Text files with delimiters

Databases

  • PostgreSQL
  • MySQL / MariaDB
  • SQL Server
  • Oracle
  • MongoDB

Cloud Storage

  • AWS S3
  • Google Cloud Storage
  • Azure Blob Storage
  • Dropbox
  • Google Drive

Business Applications

  • Salesforce
  • HubSpot
  • QuickBooks
  • Shopify
  • Zendesk

Don't see your data source?

We're constantly adding new integrations. If you don't see your preferred data source listed, contact our support team to discuss custom integration options.

Contact Support

File Upload Integration

How to Upload Files

  1. 1

    Navigate to "Data Sources" in your project

  2. 2

    Click "Upload Files"

  3. 3

    Select the file(s) from your computer

    You can select multiple files to upload at once

  4. 4

    Configure column mappings and data types if needed

    Fluxjiva will automatically detect data types, but you can override them if necessary

  5. 5

    Click "Upload" to complete the process

File Size Limits

File upload limits depend on your subscription plan:

  • Explorer: Up to 100MB per file, 1GB total
  • Business: Up to 500MB per file, 10GB total
  • Enterprise: Custom limits based on contract

Supported File Formats

For the best experience, ensure your files follow these guidelines:

  • CSV: UTF-8 encoded with header row
  • Excel: .xlsx or .xls with data in the first sheet
  • JSON: Array of objects or newline-delimited JSON

Pro Tips for File Uploads

  • Use descriptive column names

    Clear column names help Fluxjiva understand your data and generate better insights.

  • Ensure consistent data formats

    Use consistent date formats, number formats, and text conventions throughout your data.

  • Include a unique identifier column

    A unique ID for each row makes it easier to track and update data over time.

Database Connection

How to Connect a Database

  1. 1

    Navigate to "Data Sources" in your project

  2. 2

    Click "Connect Database"

  3. 3

    Select your database type

  4. 4

    Enter the connection details:

    • Host/Server
    • Port
    • Database name
    • Username
    • Password
    • SSL options (if applicable)
  5. 5

    Test the connection

  6. 6

    Select the tables or views you want to analyze

  7. 7

    Click "Connect" to complete the setup

Security Considerations

Fluxjiva takes database security seriously. Here's how we protect your connection:

  • Encrypted connections

    All database connections use TLS/SSL encryption to protect data in transit.

  • Secure credential storage

    Database credentials are encrypted at rest using AES-256 encryption.

  • Read-only access

    We recommend using read-only database users for Fluxjiva connections.

  • IP whitelisting

    For additional security, you can whitelist Fluxjiva's IP addresses in your database firewall.

Best Practices for Database Connections

  • Create a dedicated read-only user

    Create a specific database user with read-only permissions for Fluxjiva to use.

  • Use views for complex data

    Create database views to simplify complex data structures before connecting to Fluxjiva.

  • Consider connection pooling

    For high-traffic databases, set up connection pooling to minimize the impact of Fluxjiva's queries.

API Integration

How to Connect an API

  1. 1

    Navigate to "Data Sources" in your project

  2. 2

    Click "API Integration"

  3. 3

    Select the API type or choose "Custom API"

  4. 4

    Configure the API settings:

    • Endpoint URL
    • Authentication method (API key, OAuth, etc.)
    • Request parameters
    • Response format
  5. 5

    Test the API connection

  6. 6

    Configure data mapping

    Map API response fields to Fluxjiva's data model

  7. 7

    Set refresh schedule (if applicable)

  8. 8

    Click "Connect" to complete the setup

Supported Authentication Methods

  • API Key (header or query parameter)
  • Basic Authentication
  • OAuth 2.0
  • JWT
  • Custom Authentication

API Response Formats

  • JSON (recommended)
  • XML
  • CSV
  • Plain text (with custom parsing)

Advanced API Features

  • Pagination handling

    Fluxjiva can automatically handle paginated API responses to collect all data.

  • Rate limit awareness

    Our system respects API rate limits and implements backoff strategies when needed.

  • Transformation scripts

    Apply custom JavaScript transformations to API responses before analysis.

  • Webhook support

    Set up webhooks to receive real-time data updates from supported services.

Data Refresh Options

Keeping Your Data Fresh

Fluxjiva offers several options for keeping your data up to date, ensuring your analyses always reflect the most current information:

Manual Refresh

Update your data on demand with a single click. Ideal for data that changes infrequently or when you need to control exactly when updates occur.

Available on all plans

Scheduled Refresh

Set up automatic refreshes at specified intervals. Choose from hourly, daily, weekly, or monthly schedules to match your data update frequency.

Explorer: Weekly minimum interval
Business: Daily minimum interval
Enterprise: Hourly minimum interval

Real-time Sync

Maintain a continuous connection to your data source for immediate updates. Ideal for time-sensitive analytics and dashboards that need to reflect changes as they happen.

Available for Enterprise customers only

How to Configure Data Refresh

  1. 1

    Navigate to "Data Sources" in your project

  2. 2

    Select the data source you want to configure

  3. 3

    Click "Refresh Settings"

  4. 4

    Choose your preferred refresh option:

    • Manual: Refresh only when you click the refresh button
    • Scheduled: Set up a recurring schedule
    • Real-time: Enable continuous updates (Enterprise only)
  5. 5

    Configure the schedule if applicable

    For scheduled refreshes, set the frequency, time, and day as needed

  6. 6

    Save your settings

Refresh Notifications

Stay informed about your data refresh status with automated notifications:

  • Success notifications

    Receive confirmation when your data refreshes successfully.

  • Error alerts

    Get notified immediately if a refresh fails, with details about the issue.

  • Schedule reminders

    Receive reminders about upcoming scheduled refreshes.

Configure notification preferences in your user settings.

Troubleshooting Connection Issues

Common Connection Problems

Database Connection Failures

  • Check credentials: Verify username, password, and database name are correct
  • Firewall settings: Ensure your database allows connections from Fluxjiva's IP addresses
  • SSL requirements: Some databases require SSL connections - check your configuration

API Integration Issues

  • API key validation: Ensure your API key is active and has the necessary permissions
  • Endpoint URL: Verify the API endpoint URL is correct and accessible
  • Rate limits: Check if you've exceeded the API's rate limits

File Upload Problems

  • File format: Ensure your file is in a supported format and properly formatted
  • File size: Check if your file exceeds the size limits for your plan
  • Character encoding: Use UTF-8 encoding to avoid character issues

Getting Help

If you're still experiencing connection issues after troubleshooting:

  • Check our knowledge base

    Our documentation includes detailed troubleshooting guides for common issues.

  • Contact support

    Our technical support team can help diagnose and resolve connection problems.

    Contact Support

  • Schedule a consultation

    Business and Enterprise customers can schedule a call with a data integration specialist.

Next Steps

Ready to Analyze Your Data?

Once your data is connected, you can:

  • Start an analysis

    Begin exploring your data with Fluxjiva's AI-powered analytics.

    Learn about Analysis Stages

  • Configure data cleaning rules

    Set up rules to handle missing values, outliers, and data formatting.

  • Set up data transformations

    Create calculated fields, aggregations, and custom metrics.

  • Build your first dashboard

    Create visualizations and dashboards to share insights with your team.

    View Tutorials