Connecting to Databases and APIs
Last updated August 14, 2024
Deltaray empowers you to work with data from diverse sources, going beyond simple CSV files. You can directly connect to databases and APIs, bringing your information into Deltaray for seamless transformation and analysis.
Connecting to Databases
- Create a New Project: In Deltaray, create a new project that will hold the data from your database connection.
- Choose Data Ingestion: Within your project, navigate to the "Data Ingestion" section.
- Select "Database": Select "Database" as your data source.
- Select Your Database Type: Choose the type of database you want to connect to (e.g., MySQL, PostgreSQL, MongoDB, etc.).
- Provide Connection Details: Enter the necessary database connection information:
- Host: The server address of your database.
- Port: The port number your database is listening on.
- Database: The name of the database you want to access.
- Username: Your database username.
- Password: Your database password.
- Test Connection: Deltaray will attempt to connect to your database. Test the connection to ensure everything is set up correctly.
- Select Tables: After a successful connection, Deltaray will display a list of tables available in your database. Select the tables you want to import.
- Define Schema: Deltaray will automatically detect the schema of your chosen tables. You can adjust the data types of fields if needed.
- Create Datasets: Click "Create Datasets" to import your database tables into Deltaray.
Connecting to APIs
- Create a New Project: Begin by creating a new Deltaray project.
- Choose Data Ingestion: Navigate to the "Data Ingestion" section within your project.
- Select "API": Select "API" as your data source.
- Provide API Details: Enter the necessary information:
- API URL: The endpoint URL of your API.
- HTTP Method: The HTTP method to use (e.g., GET, POST).
- Headers: Any required headers for the API request.
- Authorization: If the API requires authentication, you'll need to provide credentials.
- Test Connection: Deltaray will test the connection to your API. Make sure you have the correct credentials and endpoint information.
- Preview Data: Deltaray will preview data returned from your API request.
- Define Schema: You can adjust the field types and names from the API data preview.
- Create Datasets: Once satisfied with the data preview and schema, click "Create Datasets" to import data from your API.
Deltaray provides a flexible way to connect to various data sources, empowering you to harness the power of your data, regardless of where it resides.
Was this article helpful?