Static Analyzer For Integration Services Packages

  •        36

The parser check Best practice guidelines in Business Intelligence projects. Packages can be studied which are created with Visual Studio 2010.

http://staticanalyzer.codeplex.com/

Tags
Implementation
License
Platform

   




Related Projects

Microsoft SQL Server Metadata-Driven ETL Management Studio (MDDE)


Originally an internal MSIT solution that has been released as an open source project, the Microsoft SQL Server Metadata-Driven ETL Management Studio (a.k.a. MDDE) provides a tool for rapidly generating SQL Server Integration Services (SSIS) packages from a shared central metadat

hbase-etl - ETL helpfull MR package for hbase


ETL helpfull MR package for hbase

PackageMetadataExtractor


Package Metadata Extractor is a C# project that reads column information from a SQL Server 2005 DTSX package and writes it into a SQL database, making it easier to obtain error information in SSIS packages. The resultant table can be used in a Lookup.

SSIS Event Log Business Intelligence


The SSIS Event Log Business Intelligence package is a complete BI project focused around SSIS Event Log data. Components include: - 9 SSRS Reports - ETL Data Mart - SSIS packages to load ETL Data Mart - Analysis Services Cube - PerformancePoint Dashboard

etl-package - An ETL Framework using cbmi/dataExpress


An ETL Framework using cbmi/dataExpress



LearnAnalytics-SQLServerRServices - A one day instructor-led course showcasing the SQL Server R Services architecture and best practices


Welcome to the SQL Server R Services Repository. You can find the latest materials from the workshop here. This course is intended for data scientists and SQL analysts interested in the R Services feature that was released with SQL Server 2016. We review the two common architectures that R and SQL Server use to communicate with each other. We see how we can do in-database analytics directly from our favorite R IDE (Visual Studio with RTVS or RStudio). We see how Microsoft R's RevoScaleR package can help us scale the analytics when the data is large. We examine different use cases and in the process of implementing them we learn about some best practices to follow to take full advantage of both SQL Server and R.You will find all the rendered course content in student_resources. If you wish to run the code you can open the Rmd files in instructor_resources in your R IDE.

node-require-s--best-practices - Some best practices / conventions when using Node's `require()`


Some best practices / conventions when using Node's `require()`

ETL Framework


This ETL Framework supports dynamic configurations and centralized logging for SSIS solutions in support of minimizing ETL TCO. It consists of an ETL Framework database, SSRS reports and template SSIS packages.

alfresco-etl-connector


The ETL Connector extension for Alfresco allows mass import of documents in an Alfresco repository by using compatible ETL Tools (for now Talend). It also provides an ETL client library that makes it easy to integrate in any ETL tool.

HelloWorld-Rhino-ETL - Simple examples of Rhino ETL the C Sharp ETL library


Simple examples of Rhino ETL the C Sharp ETL library

pypkg - A Python package to demonstrate best practices


Pypkg is an example package that exists as an aid to the Python Packaging User Guide Tutorial and demonstrates best practices for Python packages. This project was forked from github.com/pypa/sampleproject.

pat - Go package for patterns and best practices


Go package for patterns and best practices.

Conventions - All of my programming best practices and conventions in Markdown formatted files.


All of my programming best practices and conventions in Markdown formatted files.

Python for .NET - Python integration with the .NET


Python for .NET is a package that gives Python programmers nearly seamless integration with the .NET Common Language Runtime (CLR) and provides a powerful application scripting tool for .NET developers. Using this package you can script .NET applications or build entire applications in Python, using .NET services and components written in any language that targets the CLR (Managed C++, C#, VB, JScript).

OpenGroupware Coils


Originally a reimplementation of OpenGroupware's ZideStore. While compatible with legacy ZideStore Coils provides a sophisticated workflow system with ETL and integration capabilities and superior WebDAV/CalDAV features and compatibility. The workflow engine suppports processes described in BPML and provides integration with a variety of services include SSH, LPD, LDAP, and relation databases.

stetl


Stetl, Streaming ETL, is a lightweight, geospatial ETL framework. Stetl uses existing transformation tools like GDAL/OGR and XSLT and is glued through Python. A config file specifies an ETL chain of modules. Stetl is speed-optimized by using native calls like ogr2ogr, libxml and libxslt (via lxml). Stetl is in particularly meant in ETL cases where either ogr2ogr or XSLT alone is not sufficient. This mostly involves schema transformations as required for INSPIRE and local GML-based complex datase

tinytl - Lightweight ETL in Ruby (experimental fork of activewarehouse-etl)


Lightweight ETL in Ruby (experimental fork of activewarehouse-etl)

ETW2JSON - Tool and library to convert ETW logs to JSON files


ETW2JSON is a tool that converts ETW Log Files (.ETL) to JSON using the Newtonsoft.Json library. It can be used as a stand-alone command line tool that will take as input locations of ETL files and an output path, or it can take your implementation of Newtonsoft.Json's JsonWriter class.Converting ETW Log Files (.ETL) to JSON makes accessible to you a plethora of data that was previously restricted to expert ETW tools or libraries. The goal of this tool is to make ETW data more accessible to a larger developer and operations audience by converting to a human-readable format that is ubiquitous.

KETL


KETL(tm) is a production ready ETL platform. The engine is built upon an open, multi-threaded, XML-based architecture. KETL's is designed to assist in the development and deployment of data integration efforts which require ETL and scheduling

MixDEM


MixDEM a web based ETL tools meant for Web integration, Data transformation and Mashup edition. It include MixDEM ETL Engine created using ZEND Framework, and MixDEM GUI Editor an AJAX IDE that enable developers to quickly and easily create applications.