​

Connecting Data Sources

Infactory can connect to various types of databases to enable intelligent query generation. This guide explains how to connect your data sources and get the most out of the automatic schema analysis.

​

Supported Data Sources

Infactory currently supports the following data sources:

• Azure Cosmos DB: NoSQL database service for modern app development
• PostgreSQL: Powerful, open source object-relational database system
• MySQL: Open-source relational database management system

Additional data sources are being added regularly. If you need a custom connection, please contact our support team.

​

Connecting to Azure Cosmos DB

Azure Cosmos DB is a fully managed NoSQL database service that offers multi-region writes, elastic scaling, and comprehensive SLAs.

​

Connection Requirements

To connect to an Azure Cosmos DB database, you’ll need:

• Connection URL: The endpoint URL for your Cosmos DB instance
• Key: The primary or secondary key for accessing your Cosmos DB account
• Database Name: The name of the database you want to connect to

​

Connection Steps

1. Navigate to the Connect tab in your Infactory project
2. Select Azure Cosmos DB from the available data sources
3. Enter your connection details:
   • Connection URL: Your Cosmos DB endpoint URL (e.g., https://your-account.documents.azure.com:443/)
   • Key: Your Cosmos DB access key
   • Database Name: The name of your Cosmos DB database
4. Click Connect

​

Container Selection

After connecting, Infactory will display the available containers in your database. You can:

• Select specific containers to include in your project
• Write custom queries to filter or transform the data within containers

​

Connecting to PostgreSQL

PostgreSQL is a powerful, open-source object-relational database system with over 30 years of active development.

​

Connection Requirements

To connect to a PostgreSQL database, you’ll need:

• Host: The hostname or IP address of your PostgreSQL server
• Port: The port number (typically 5432)
• Username: Your database username
• Password: Your database password
• Database Name: The name of the database you want to connect to

​

Connection Steps

1. Navigate to the Connect tab in your Infactory project
2. Select PostgreSQL from the available data sources
3. Enter your connection details:
   • Host: Your PostgreSQL server hostname or IP address
   • Port: The port number (typically 5432)
   • Username: Your database username
   • Password: Your database password
   • Database Name: The name of your PostgreSQL database
4. Click Connect

​

Table Selection

After connecting, Infactory will display the available tables in your database. You can:

• Select specific tables to include in your project
• Write custom queries to filter or transform the data within tables

​

Data Model Generation

After connecting to your data source, Infactory automatically:

1. Samples your data to understand its structure
2. Identifies data types and relationships between tables/collections
3. Generates descriptive names and metadata for your data
4. Creates a data model that powers intelligent query generation

​

Viewing and Editing the Data Model

The generated data model can be viewed and edited:

1. Navigate to the Connect tab
2. Select a table or container
3. View the Table View to see the field names, types, and descriptions
4. Switch to Code View to see and edit the underlying data model code

​

Customizing the Data Model

You can customize the data model to provide additional context that helps Infactory better understand your data:

1. Edit field descriptions to provide more context about what the data represents
2. Adjust data types if automatic detection didn’t get them right
3. Add custom display names to make fields more human-readable

​

Working with Complex Data Sources

​

Multiple Tables/Collections

Infactory can work with multiple tables or collections within the same data source. This enables queries that span related data.

​

Custom Queries as Data Sources

For complex data models or specific data needs, you can provide a custom SQL query or MongoDB query as your data source:

1. Select “Custom Query” when connecting to your data source
2. Write the query that retrieves exactly the data you need
3. Click “Test Query” to validate
4. Click “Connect” to use this as your data source

​

Best Practices

• Data Quality: Clean, well-structured data yields better automatic query generation
• Field Naming: Clear, descriptive field names help Infactory understand your data
• Schema Complexity: Start with simpler schemas and add complexity as needed
• Custom Descriptions: Add custom descriptions to fields that might be ambiguous or technical
• Sample Data: Ensure your database contains representative sample data for best results

​

Next Steps

After connecting your data sources, Infactory will automatically generate queries based on your schema. Continue to Building Queries to learn how to work with these queries and create new ones.