SQL SERVER – Partition Parallelism Support in expressor 3.6

I am very excited to learn that there is a new version of expressor’s data integration platform coming out in March of this year.  It will be version 3.6, and I look forward to using it and telling everyone about it.  Let me describe a little bit more about what will be so great in expressor 3.6:

  • Greatly enhanced user interface
  • Parallel Processing
  • Bulk Artifact Upgrading

The User Interface

ex1 SQL SERVER   Partition Parallelism Support in expressor 3.6First let me cover the most obvious enhancements. The expressor Studio user interface (UI) has had some significant work done. Kudos to the expressor Engineering team; the entire UI is a visual masterpiece that is very responsive and intuitive. The improvements are more than just eye candy; they provide significant productivity gains when developing expressor Dataflows.

Operator shape icons now include a description that identifies the function of each operator, instead of having to guess at the function by the icon.

ex2 SQL SERVER   Partition Parallelism Support in expressor 3.6Operator shapes and highlighting depict the current function and status: Disabled, enabled, complete, incomplete, and error. Each status displays an appropriate message in the message panel with correction suggestions.

ex3 SQL SERVER   Partition Parallelism Support in expressor 3.6Floating or docking property panels provide descriptive tool tips for each property as well as auto resize when adjusting the canvas, without having to search Help or the need to scroll around to get access to the property.

ex4 SQL SERVER   Partition Parallelism Support in expressor 3.6

Progress and status indicators let you know when an operation is working.

ex5 SQL SERVER   Partition Parallelism Support in expressor 3.6“No limit” canvas with snap-to-grid allows automatic sizing and accurate positioning when you have numerous operators in the Dataflow. The inline tool bar offers quick access to pan, zoom, fit and overview functions.

Selecting multiple artifacts with a right click context allows you to easily manage your workspace more efficiently.

Partitioning and Parallel Processing

ex7 SQL SERVER   Partition Parallelism Support in expressor 3.6Partitioning allows each operator to process multiple subsets of records in parallel as opposed to processing all records that flow through that operator in a single sequential set. This capability allows the user to configure the expressor Dataflow to run in a way that most efficiently utilizes the resources of the hardware where the Dataflow is running. Partitions can exist in most individual operators. Using partitions increases the speed of an expressor data integration application, therefore improving performance and load times. With the expressor 3.6 Enterprise Edition, expressor simplifies enabling parallel processing by adding intuitive partition settings that are easy to configure.

Bulk Artifact Upgrading

ex8 SQL SERVER   Partition Parallelism Support in expressor 3.6Bulk Artifact Upgrading sounds a bit intimidating, but it actually is not and it is a welcome addition to expressor Studio. In past releases, users were prompted to confirm that they wanted to upgrade their individual artifacts only when opened. This was a cumbersome and repetitive process. Now with bulk artifact upgrading, a user can easily select what artifact or group of artifacts to upgrade all at once.

As you can see, there are many new features and upgrade options that will prove to make expressor Studio quicker and more efficient.  I hope I’m not the only one who is excited about all these new upgrades, and that I you try expressor and share your experience with me.

Reference: Pinal Dave (http://blog.sqlauthority.com)

2 thoughts on “SQL SERVER – Partition Parallelism Support in expressor 3.6

  1. Hi members iam looking for a code that can help me find empty periods in a school time table and it automatically fill fill those periods with the subject and teachers initials. this code should combine the teachers intintals + the subject initials + the class where the lesson is going to be held and also check on the conflicts of defferent lessons.

    Please help how can i go about it


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s