Import and Export Data

If you are working with data stored in a database or hosted somewhere on the cloud, it's often simpler and more efficient to load your data directly into Graphext. By connecting a database or remotely hosted dataset with Graphext, you create a link between your workspace and the source of your data.

You only have to integrate a data source with your Graphext workspace once. Then each time you want to work with this data you can fetch it from your source by selecting 'New Dataset' from your workspace. This action will retrieve your data in its most up to date form, meaning that you can start analyzing recent data straight away.

"Simplicity is the ultimate sophistication."

- Leonardo Da Vinci

To integrate a database or remotely hosted dataset with Graphext, start by selecting 'New Dataset' from the datasets panel of your Graphext workspace. Integrations are local to specific Graphext teams. They will only be active inside the team where you create the integration.

Google Drive

You can load datasets that are stored in Google Drive by providing Graphext with the URL of the dataset. To access the URL of your file within Google Drive, right-click on the file inside your Drive and select 'Get Link'.

Since Google Drive integrations require Graphext to view your Google Drive files, you don't have worry about changing the permissions associated with this link in any way.

How to Connect Datasets on Google Drive?

  1. Start from the 'Datasets' panel of your Graphext workspace.
  2. Make sure you are working within the correct team's workspace.
  3. Select 'New Dataset'.
  4. Select 'Add Integration'.
  5. Within the team settings window that appears, select 'Add Integration' under the Data Storage heading.
  6. Select 'Google Drive' as your new integration.
  7. Click 'Connect'.
  8. Choose the account where your file is stored from the Google sign in window that appears.
  9. Select 'Allow' from the Google sign in permissions window.
  10. Great, you are connected. Now find your file within your Google Drive.
  11. Right click on the file and select 'Get Link'.
  12. Copy the link.
  13. Paste it into the textbox inside of your Graphext - Google Drive integration window.
  14. Click 'OK' and then 'Done'.
  15. You've made the integration.
  16. To fetch the data, select the integration you've just made from the 'Adding Dataset' window.
  17. Select 'Fetch'.
  18. Done ... Your data will load inside the 'Datasets' panel of your workspace.


Google Sheets

You can connect a Google Sheets file with Graphext to start analyzing the data inside of it. Copy and paste the link of the sheets file into the integrations window of your team's settings to create the integration.

How to Connect Google Sheets?

  1. Start from the 'Datasets' panel of your Graphext workspace.
  2. Make sure you are working within the correct team's workspace.
  3. Select 'New Dataset'.
  4. Select 'Add Integration'.
  5. Within the team settings window that appears, select 'Add Integration' under the Data Storage heading.
  6. Select 'Google Sheets' as your new integration.
  7. Click 'Connect'.
  8. Choose the account where your file is stored from the Google sign in window that appears.
  9. Select 'Allow' from the Google sign in permissions window.
  10. Great, you are connected. Now find your file within your Google Sheets account.
  11. Open the Google Sheets file.
  12. Click 'Share' from the top right of your Sheets file.
  13. Select 'Copy link' from the 'Get link' section of the 'Share' window.
  14. Paste the link into the textbox inside of your Graphext - Google Sheets integration window.
  15. Click 'OK' and then 'Done'.
  16. You've made the integration.
  17. To fetch the data, select the integration you've just made from the 'Adding Dataset' window.
  18. Select 'Fetch'.
  19. Done ... Your Google Sheets data will load inside the 'Datasets' panel of your workspace.


Google BigQuery

You can integrate your team's Graphext workspace with data from Google BigQuery projects by adding a Google BigQuery integration. To do this you must authorize Graphext to view and manage your data in BigQuery.

Then, all you have to do is enter the ID of the project where your data is stored and provide an SQL query to match specific data. Creating this integration means you can pull fresh data from a BigQuery project whenever you need to.

How to Connect Google BigQuery?

  1. Start from the 'Datasets' panel of your Graphext workspace.
  2. Make sure you are working within the correct team's workspace.
  3. Select 'New Dataset'.
  4. Select 'Add Integration'.
  5. Within the team settings window that appears, select 'Add Integration' under the Data Storage heading.
  6. Select 'BigQuery' as your new integration.
  7. Click 'Connect'.
  8. Choose the account to connect Graphext to BigQuery.
  9. Select 'Allow' from the Google sign in permissions window.
  10. Great, you are connected.
  11. Copy and paste the ID of the BigQuery project you want to integrate with Graphext.
  12. Using the 'Query' field, optionally enter an SQL query to match your results with specific data.
  13. Click 'OK' and then 'Done'.
  14. You've made the integration.
  15. To fetch the data, select the integration you've just made from the 'Adding Dataset' window.
  16. Select 'Fetch'.
  17. Done ... Data from your BigQuery project will load as a dataset inside the 'Datasets' panel of your workspace.


Google Cloud Storage

If you store data using Google Cloud Storage, you can regularly pull data directly from buckets by integrating the bucket with your team's Graphext workspace. First, create an integration with Google Cloud Storage using the 'New Dataset' button inside your 'Datasets' panel and give Graphext permission to view your data in Google Cloud Storage.

Then, enter the name of the bucket and source blob as well as the project ID and you are good to go!

How to Connect Google Cloud Storage?

  1. Start from the 'Datasets' panel of your Graphext workspace.
  2. Make sure you are working within the correct team's workspace.
  3. Select 'New Dataset'.
  4. Select 'Add Integration'.
  5. Within the team settings window that appears, select 'Add Integration' under the Data Storage heading.
  6. Select 'Google CS' as your new integration.
  7. Click 'Connect'.
  8. Choose the account to connect Graphext to Google Cloud Storage.
  9. Select 'Allow' from the Google sign in permissions window.
  10. Great, you are connected.
  11. Enter the bucket name, source blob name and project ID of the bucket you want to integrate with Graphext.
  12. Click 'OK' and then 'Done'.
  13. You've made the integration.
  14. To fetch the data, select the integration you've just made from the 'Adding Dataset' window.
  15. Select 'Fetch'.
  16. Done ... Data from the Google Cloud Storage bucket will load as a dataset inside the 'Datasets' panel of your workspace.


Amazon S3

Graphext allows you to integrate with Amazon S3 so that you can pull data directly from buckets you host using Amazon S3. After creating an integration, you can regularly fetch data from your connected Amazon S3 buckets.

To do this, you must provide Graphext with your AWS access key and access secret along with a region name, bucket and path.

How to Connect an Amazon S3 Bucket?

  1. Start from the 'Datasets' panel of your Graphext workspace.
  2. Make sure you are working within the correct team's workspace.
  3. Select 'New Dataset'.
  4. Select 'Add Integration'.
  5. Within the team settings window that appears, select 'Add Integration' under the Data Storage heading.
  6. Select 'Amazon S3' as your new integration.
  7. Complete the form by entering your AWS access key, access secret, region, bucket and path.
  8. Click 'OK' and then 'Done'.
  9. You've made the integration.
  10. To fetch the data, select the integration you've just made from the 'Adding Dataset' window.
  11. Select 'Fetch'.
  12. Done ... Data from your Amazon S3 bucket will load as a dataset inside the 'Datasets' panel of your team's workspace.


Microsoft Azure

You can create integrations between Graphext and data you store in Microsoft Azure Blobs. Integrations you make with Azure Blobs will pull data directly from your Blob into your team's Graphext workspace.

Start connecting a Blob with Graphext by adding a 'New Dataset' in the 'Datasets' panel of your team's workspace. Then select 'Microsoft Azure' as the integration type you would like to make. Finally, add your account information along with the name of the Blob and the container in which it is stored to complete your integration.

How to Connect a Microsoft Azure Blob?

  1. Start from the 'Datasets' panel of your Graphext workspace.
  2. Make sure you are working within the correct team's workspace.
  3. Select 'New Dataset'.
  4. Select 'Add Integration'.
  5. Within the team settings window that appears, select 'Add Integration' under the Data Storage heading.
  6. Select 'Microsoft Azure' as your new integration.
  7. Complete the form by entering your account name, account key, container name and blob name.
  8. Using the 'Query' field, optionally enter an SQL query to match your results with specific data from your database.
  9. Click 'OK' and then 'Done'.
  10. You've made the integration.
  11. To fetch the data, select the integration you've just made from the 'Adding Dataset' window.
  12. Select 'Fetch'.
  13. Done ... Data from your Microsoft Azure Blob will load as a dataset inside the 'Datasets' panel of your team's workspace.


PostgreSQL

You can pull data directly from postgreSQL databases into Graphext by connecting your database to your team's workspace. To do this, you will need to provide your database username, password, host, port and database key.

Additionally, you can fetch data from your postgreSQL database matching a specific query by entering an SQL query into the 'Query' field as you create your integration. The integration you make can be used to fetch new data using this query as many times as you need.

How to Connect a PostgreSQL Database?

  1. Start from the 'Datasets' panel of your Graphext workspace.
  2. Make sure you are working within the correct team's workspace.
  3. Select 'New Dataset'.
  4. Select 'Add Integration'.
  5. Within the team settings window that appears, select 'Add Integration' under the Data Storage heading.
  6. Select 'PostgreSQL' as your new integration.
  7. Complete the form by entering your username, password, host, port and database key.
  8. Using the 'Query' field, optionally enter an SQL query to match your results with specific data from your database.
  9. Click 'OK' and then 'Done'.
  10. You've made the integration.
  11. To fetch the data, select the integration you've just made from the 'Adding Dataset' window.
  12. Select 'Fetch'.
  13. Done ... Data from your PostgreSQL database will load as a dataset inside the 'Datasets' panel of your team's workspace.


MySQL

You can pull data directly from MySQL databases into Graphext by connecting your database to your team's workspace. To do this, you will need to provide your database username, password, host, port and database key.

Additionally, you can fetch data from your MySQL database matching a specific query by entering an SQL query into the 'Query' field as you create your integration. The integration you make can be used to fetch new data using this query as many times as you need.

How to Connect a MySQL Database?

  1. Start from the 'Datasets' panel of your Graphext workspace.
  2. Make sure you are working within the correct team's workspace.
  3. Select 'New Dataset'.
  4. Select 'Add Integration'.
  5. Within the team settings window that appears, select 'Add Integration' under the Data Storage heading.
  6. Select 'MySQL' as your new integration.
  7. Complete the form by entering your username, password, host, port and database key.
  8. Using the 'Query' field, optionally enter an SQL query to match your results with specific data from your database.
  9. Click 'OK' and then 'Done'.
  10. You've made the integration.
  11. To fetch the data, select the integration you've just made from the 'Adding Dataset' window.
  12. Select 'Fetch'.
  13. Done ... Data from your MySQL database will load as a dataset inside the 'Datasets' panel of your team's workspace.


SQL Servers

You can pull data directly from an SQL Server into Graphext by connecting it to your team's workspace. To do this, you will need to provide your database username, password, host, port and database key.

Additionally, you can fetch data from an SQL Server matching a specific query by entering an SQL query into the 'Query' field as you create your integration. The integration you make can be used to fetch new data using this query as many times as you need.

How to Connect an SQL Server?

  1. Start from the 'Datasets' panel of your Graphext workspace.
  2. Make sure you are working within the correct team's workspace.
  3. Select 'New Dataset'.
  4. Select 'Add Integration'.
  5. Within the team settings window that appears, select 'Add Integration' under the Data Storage heading.
  6. Select 'SQL Server' as your new integration.
  7. Complete the form by entering your username, password, host, port and database key.
  8. Using the 'Query' field, optionally enter an SQL query to match your results with specific data from your database.
  9. Click 'OK' and then 'Done'.
  10. You've made the integration.
  11. To fetch the data, select the integration you've just made from the 'Adding Dataset' window.
  12. Select 'Fetch'.
  13. Done ... Data from your SQL Server will load as a dataset inside the 'Datasets' panel of your team's workspace.


Renaming Integrations

It's a good idea to give your integrations specific names to indicate what kind of data they will retrieve each time you fetch a new dataset using them.

To rename an integration, find the integrations section inside your team settings window and select 'Rename' from the menu list that appears after you've clicked on the three vertical dots on the right side of the integration card.

How to Rename an Integration?

  1. Start from the 'Datasets' panel of your Graphext workspace.
  2. Make sure you are working within the correct team's workspace.
  3. Select the icon representing team settings from your left sidebar.
  4. Under the Teams heading, select 'Integrations'.
  5. Click on the 3 vertical dots inside of the card representing the integration you want to remove.
  6. Select 'Rename' from the menu list.
  7. Enter a new name for your integration.
  8. Click 'OK'.
  9. Done ... This integration has been given a new name, making it much easier to recognise. Your team will thank you later!


Updating Integrations

You can update the integrations that you've created between databases or remotely hosted datasets and your Graphext workspace. This might involve specifying a new URL for your Google Sheets file or updating the password that you've provided for your MySQL database.

To do this, find the integrations section inside your team settings window and select 'Settings' from the menu list that appears after you've clicked on the three vertical dots on the right side of the integration card. Then enter your new details into the form that appears.

How to Update an Integration?

  1. Start from the 'Datasets' panel of your Graphext workspace.
  2. Make sure you are working within the correct team's workspace.
  3. Select the icon representing team settings from your left sidebar.
  4. Under the Teams heading, select 'Integrations'.
  5. Click on the 3 vertical dots inside of the card representing the integration you want to remove.
  6. Select 'Settings' from the menu list.
  7. Enter your new information into the relevant integration fields.
  8. Click 'Update'.
  9. Done ... Next time you fetch data using this integration, your newly updated information will be used.


Removing Integrations

You can remove integrations that you've created between databases or remotely hosted datasets and your Graphext workspace.

To do this, find the integrations section inside your team settings window and select 'Delete' from the menu list that appears after you've clicked on the three vertical dots on the right side of the integration card.

How to Remove an Integration?

  1. Start from the 'Datasets' panel of your Graphext workspace.
  2. Make sure you are working within the correct team's workspace.
  3. Select the icon representing team settings from your left sidebar.
  4. Under the Teams heading, select 'Integrations'.
  5. Click on the 3 vertical dots inside of the card representing the integration you want to remove.
  6. Select 'Delete' from the menu list.
  7. Done ... This integration has been removed from your team.

Need Something Different?

We know that data isn't always clean and simple.
Have a look through these topics if you can't see what you are looking for.