CARTO Introduces Direct SQL Connection for QGIS and Databricks - Geospatial World

CARTO Introduces Direct SQL Connection for QGIS and Databricks

CARTO has announced the new Direct SQL Connection feature, available now to all enterprise customers. With this new feature, you can bring your CARTO data to other tools you already use, such as QGIS, Databricks, PowerBI, and more—securely connecting to your CARTO database from any application that supports PostgreSQL as a data source.

Some use cases

This feature opens a world of possibilities, like:

1. Advanced GIS editing or geoprocessing from desktop tools like QGISYou can connect from QGIS to your CARTO database using a regular PostGIS connection. Then you can use QGIS to create new datasets, edit existing datasets with QGIS remarkable editing capabilities or create complex spatial analysis models over CARTO datasets using the QGIS processing framework.
2. Using CARTO data in BI applications reports and dashboards like Power BI or TableauYou can access your CARTO database from BI applications using ODBC or JDBC connectors. Then you can create dashboards or reports where you use the request in your CARTO datasets.
3. Improving your data science workflows developed with data analytics platforms like DatabricksYou can connect directly your Databricks cluster to your CARTO database using a JDBC connection from your notebook. Then you can read data from your CARTO dataset using dataframes and take advantage of Databricks functionality for cleaning, transforming or enriching your datasets and, finally, write back the transformed data to CARTO.
4. Integrate CARTO datasets in your ETL pipelinesYou can use your CARTO datasets within your ETL pipelines developed with tools like Talend. Using these tools you can transform and move your data in and out of your CARTO database and take advantage of the ETL tools capabilities to integrate CARTO with data warehouses like Snowflake and Vertica or cloud storage services like Amazon S3 and Google Cloud Storage.

How to get started

This feature is available right now to all enterprise customers. To start using it, just go to the settings page in your dashboard and follow the instructions to set up a new connection. You can find information about the new Direct SQL Connection and tutorials for connecting with different applications in the help center. If you encounter any issues, just reach out to your Customer Success Manager.

Thanks for watching our article CARTO Introduces Direct SQL Connection for QGIS and Databricks - Geospatial World. Please share it with pleasure.
Sincery All Tips collection
SRC: https://www.geospatialworld.net/news/carto-introduces-direct-sql-connection-for-qgis-and-databricks/

powered by Blogger News Poster

Tweet