JerodJ


SQLServerCentral Article

Use SQLAlchemy ORMs to Access MongoDB Data in Python

The wide ecosystem of Python modules enables you get to work fast and effectively integrate your systems. You can use the CData Python Connector for MongoDB and the SQLAlchemy toolkit to build MongoDB-connected Python applications and scripts.  This article details how to use SQLAlchemy to connect to MongoDB data to query, update, delete, and insert MongoDB data.  Connecting to MongoDB Data  Connecting to MongoDB data is similar to connecting to any other relational database. Create a […]

2021-09-22

1,197 reads

SQLServerCentral Article

Prepare, Blend, and Analyze Salesforce Data in Alteryx Designer 

The ODBC Driver for Salesforce from CData provides ODBC-based access to live Salesforce data, allowing you to interact with Salesforce data in a range of BI, reporting, and ETL tools — as well as directly using SQL queries. In this article, we demonstrate how to connect to Salesforce data using an ODBC connection in Alteryx Designer to conduct self-service BI, data preparation, data blending, and advanced […]

5 (1)

2021-09-15

384 reads

SQLServerCentral Article

Use SQL Server Integration Services to Add HubSpot Contacts to MailChimp Lists

SSIS stands for SQL Server Integration Services and is a solution for building data integrations and workflow applications that integrate with SQL Server databases. As data integration processes increase in importance, organizations are looking for ways to simplify integration and manage workflows.  In this article, we'll walk you through how to design a data flow that adds new HubSpot contacts to a MailChimp list using CData SSIS Components for HubSpot and MailChimp.  Connecting to HubSpot and MailChimp  The […]

5 (1)

2021-09-03 (first published: )

590 reads

Blogs

RMOUG Training Days in Denver

By

Next week I’m heading to the Lowry Conference Center in Denver for the RMOUG...

Daily Coping 7 Feb 2023

By

Today’s coping tip is to go to bed in good time and allow yourself...

Tales From The Field Weekly Wrap Up for the Week of 01-31-2023

By

 Hello Dear Reader!  After a weekend with a lot of activities, it was a...

Read the latest Blogs

Forums

how to make a col in a table after checking its existence, in one stmt

By rajemessage 14195

hi, IF NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME ='abc' AND COLUMN_NAME IN...

Coaching the Digital Transformation

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Coaching the Digital Transformation

A Version Control Strategy for Branch-based Database Development

By Tonie Huizer

Comments posted to this topic are about the item A Version Control Strategy for...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers