xFusion Community Contributions
Data Cleansing
Applications use database to capture and store data. As these applications are programmed and run manually
there is possibilty to have bad data in the database. Analysis and reporting on incorrect data can be devastating.
The primary challenge has been data profiling to identify bad data and then cleansing of bad data.
In this article, we look at how to identify and clean bad data based on some rules using xFusion.
For marketing campaigns, it is sometimes desired to build the email list of all
the people who you have interacted with. Your Outlook Address Book most likely contains
just a subset of such an email list. In this article, we look at how you can use
xFusion Studio to build a clean SMTP ready email address list.
In this article, we look at how you can process Exchange Server non-deliverable
reports (NDR) from Windows Application Event Log to identify undelivered emails.
It is a common scenario that a SAP Business one database contains invalid vendors that do not have any journal entries on it.
This article shows how one can use xFusion Studio to delete such invalid vendors, from a SAP business one database.
Data Processing
This article shows how xFusion can be used to upload files to a FTP site.
In this article, we look at using xFusion Studio to send bulk emails to your contacts.
This article demonstrates how HTML formatted output can be generated from xFusion
and different ways to use the generated output.
This article shows the most common conversions between DateTime type field
and textual (string) formats
SQL Server
SQL Server Profiler shows how Microsoft SQL Server resolves queries internally.
In this article, I will show how xFusion Studio helps analyze long running queries and store procedures.
Microsoft SQL Server 2005 enhanced T-SQL with many new functions. In this article,
we look at the top five analytical functions that have been introduced.
Performance Optimization
To achieve significant performance in data upload to SQL
server or Oracle you can
use the bulk insert option in xFusion. Read this article to know how this feature
improves your performance.
Configuration
By default, xFusion repository information is saved under each user’s “Documents and Settings” directory.
Under roaming profile configuration such as that of Citrix server or Microsoft Remote Desktop Server,
your system administrator may have a policy not to persist this directory.
Under such situations, the directory is created each time the user logs on
and simply gets deleted once the user logs off. Starting version 3.0,
xFusion Studio is capable of saving the repository to an alternate location.
xFusion Scheduler
We have added xFusion Scheduler to our suite of products. xFusion Scheduler is an application that helps automate any data driven task.
Read more…
xFusion General
This article demonstrates how xFusion Studio can easily fetch all blocked vendors data from SAP. Read more...
This article demonstrates how you can use xFusion Studio to monitor the performance of an application and get notified when the performance of the application goes down.
This article demonstrates how to monitor and analyse your websites log. Read more...
This article demonstrates how xFusion can compare two data sources side-by-side, for example SAP and Microsoft Excel. Read more…
You can easily generate fixed-width format files using xFusion. Read more...
A regular expression (regex or regexp for short) is a special text string for describing a search pattern. Read more...
This article demonstrates how to convert a range of cells within Excel as a custom table and use it within xFusion Studio. Read more...
xFusion Studio supports generating the log file name dynamically based on the date and time of the run. Read more...
This article helps to generate a backup of any data source to MS SQL server. Read more...
xFusion can load pictures from file. Read more...
Data Consolidation
This article explains how xFusion Studio can help to upload specified items from your legacy system into SAP B1. Read more...
This article explains how xFusion Studio can help analyze historical data for Municipal Corportations. Read more...
|
|