Multicast Transformation in SSIS: the Simplest Export of Data to Excel and SQL Server Simultaneously (with Example)

This article is the second part of the material dedicated to SSIS Multicast Transformation used to send the report data to multiple destinations.

In the previous section, we set up the environment for doing that task – refer to it to refresh your knowledge and recall the examples. In this section, we are going to use that data to design the Multicast Transformation solution and test-run it.

So, get back to the previously created project. We are starting the next stage of our work.

CodingSight - Sending Report Data to Excel and SQL Database using Multicast Transformation in SSIS Packages
Read More

Oracle Data Integrator Tutorial: How to Import Multiple Raw Files into Oracle Autonomous Data Warehouse

When you build an ETL / ELT enterprise system, you need the Data Integration tools, such as Microsoft SQL Server Integration Service, Oracle Data Integrator (ODI), Talend, etc. These tools help you to integrate, transform, and load data from the source to the destination location.

The current article is the Oracle Data Integrator tutorial, that will explain loading multiple datafiles into an Autonomous Data Warehouse (ADW). This tool is an ELT (extract, load, transform) solution with a graphic interface, built by Oracle. It lets the users build, manage, and maintain the data integration process.

CodingSight - Importing Data into an Oracle Autonomous Data Warehouse using Oracle Data Integrator

In our case study, the system receives the Sales data files from a database. The Oracle Data Integrator needs to pick up all data files to load into the Oracle Autonomous Data Warehouse.  

Read More

Multicast Transformation in SSIS: Simplify Export of Data to Excel and SQL Server Simultaneously (with Example)

In professional work scenarios, we often need to load data from one report to several destinations, such as Excel files and SQL databases. One of the ways to accomplish this is using an Multicast Transformation in SSIS which accepts the data input and splits it into several outputs, creating logical data copies. As a result, you get several result copies to apply them to different purposes.

The current article clarifies the steps of gathering information, identifying problems, and designing the solution initial phase. Note that the material is meant for users with some backgrounds. It is desirable to be familiar with the SQL Server work, T-SQL scripting, and dedicated tools. You may refer to the following articles for details:

CodingSight - Sending Report Data to Excel and SQL Database using Multicast Transformation in SSIS Packages
Read More

How to Connect Python to SQL Server to Automate Backend Process

Automating backend processes in your SQL Server instance is a common task. Whether it is refreshing the statistics, rebuilding indexes, reading or deleting data, other programming frameworks integrating with the RDMS is extremely valuable. This article will consider these types of tasks specifically integrated with Python and various method modules available to do so.

CodingSight - SQL Server and Python
Read More

Creation of Pandas DataFrames in Python with Examples

Python is a multi-purpose programming language developed by Guido van Rossum in the late 1980s. Today, it is widely used in software engineering worldwide and across various domains. Web development, application development, IoT, Data Science, Machine Learning, and Artificial Intelligence are a few of the scope. One of the reasons why Python is so popular is its simplicity in code-writing.

Read More

9 Best Practices for Writing SQL Queries

If you are reading this article, most probably, you are already familiar with SQL. You know how to write basic SQL queries. There are many ways to execute a SQL query to get desired results on your database.

However, not all SQL queries are created equal. Most can be optimized to follow the best practice. This article focuses on 9 SQL query optimization tips. After reading, you will know all the dos and don’ts of writing SQL queries.

CodingSight - 9 Best Practices for Writing SQL Queries
Read More

Git Tips & Best Practices for Beginners

Without a version control system, it’s next to impossible to manage the source code.  You can be a software developer of C, C#, Java, or any other language, but you need version control. The best and one of the most popular version control systems is Git.

Git is a free open-source distributed version control system (VCS) used by many small and large companies. Its functionality is impressive, and many thousands of Git supporters gladly add more practices and tips to make the source control management more productive.

Currently, you can use more than 35 Git best practices and many tips. However, this article will focus on the best 11 Git tips and practices that are optimal for beginners.

CodingSight - Git Tips & Best Practices for Beginners
Read More

ASP.NET vs. PHP: the Best Framework for Web Development

The primary goal of web development teams is to deliver web applications with the best user experience, scalability, and sustainability. Hence, developers always look for the right technology stack to build with these goals.

There are various web technologies stacks like PHP, .Net, Ruby on Rails, Java, or Python. PHP and .NET are the most commonly used technologies in web development. As statistics claims, PHP and ASP.NET hold the lion’s share of the web technologies market. In most cases, development teams choose between these two variants.

Both options have their pros and cons. In this article, we’ll discuss the differences and applicability of PHP and ASP.NET.

Read More