automation

Create an RPA Flow that Connects to Oracle Data in UiPath Studio

  • Article

If your company uses legacy technology systems, you can use the UiPath RPA platform to extend your process automation capabilities to these systems and eliminate repetitive, error-prone tasks of manually updating them. By using UiPath Studio, you can build an RPA program just like drawing a diagram.  With the CData ODBC Driver for Oracle, users can embed Oracle data in the workflow.  Let’s […]

2021-09-24

151 reads

Use SQLAlchemy ORMs to Access MongoDB Data in Python

  • Article

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

163 reads

Generate Role Member Reports using dbatools and the ImportExcel PowerShell modules

  • Article

Being able to get information and save it on a Excel as a report can be a common and tedious task. What if we could join dbatools and ImportExcel PorwerShell modules to accomplish this in a easier and fast way? We will see how to export roles and its' member and save that info on a multi spreadsheet Excel file with handy tables ready to be explored.

5 (2)

2020-06-30

4,671 reads

Blogs

Daily Coping 24 Sept 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Using environment variable files for SQL Server in containers

By

There are a whole bunch of environment variables that can be used to configure...

How to Design Backups in SQL Server?

By

The Recovery Point Objective (RPO) and Recovery Time Objective (RTO) are basic concepts related...

Read the latest Blogs

Forums

Need an urgent help with creating a relational database!!

By LoneLostWolf

Hi guys, I'm quite new to T-SQL and honestly started to take online classes...

Need to Convert SQL Code Written for Azure SQLDW to SQL Server 2016

By carlton 84646

Hello Community, The attached SQL Script (Procedure) is compiled / written for Azure SQL...

SQL join based on column value

By learner0

I am trying to join two tables based on the condition. Table1: ID   ...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers