background preloader

Expressor

Facebook Twitter

Expressor Community | Resources. Extending expressor with Datascript | Blogs | expressor Community. O n the phone or on the road, I have been positioning expressor solutions that solve many data application integration challenges. On a recent call, I was asked if expressor could provision and normalize data from Facebook’s social network graph. In short the answer is yes, absolutely. Not only can it from Facebook, but it can also to it. (more on this in a future article) - In general, if there is a RESTful or SOAP API available, such as Facebook’s Graph API , then expressor can use it. (I have covered this topic once before in another article here .) This time, before I reveal specific solution details, I’d like to provide some background on the core component that makes it possible.

"Out-of-the-box", expressor provides various wizards which define reusable source and target schemas for Excel files, delimited text, Salesforce objects and database tables. {*style:<b><u>expressor Datascript and Lua </u></b>*} Datascript can be used in a number of components of an expressor Dataflow. Extracting data from the Facebook social graph with expressor, a Tutorial | Blogs | expressor Community. In my last article, Enterprise Application Integration with Social Networking Data , I describe how social networking sites, such as Facebook and Twitter, provide APIs to communicate with the various components available in these applications. One in particular, is their "social graph" API which enables software developers to create programs that can interface with the many "objects" stored within these graphs.

In this article, I will briefly review the Facebook social graph and provide a simple tutorial with an expressor downloadable project. I will cover how expressor can extract data using the Facebook graph API and flatten it by using the provided reusable Datascript Module. I will also demonstrate how to add new user defined attributes to the expressor Dataflow so one can customize the output needed. At Facebook's core is the social graph; people and the connections they have to everything they care about. Code: Download the project .zip file here Copy .zip file to temp location. Expressor: From Data to Discovery – An internet retailer story | Data Integration Simplified. Videos, Tutorials, Tips and Tricks. Expressor: Top 10 "Ease of Use" Features of expressor Studio - Part 1 | Blogs | expressor Community.

Ask any organization about what they are looking for in a software platform and I guarantee "ease of use" will come up. " " (Sheesh, if I had a dollar for every time I heard that.) I have researched and used a number of ETL tools that fit into many genres; from proprietary and open source to desktop and cloud. In this 2 part article I will not only highlight why I believe expressor's Design Studio is easy to use, but also cover where I believe education is necessary to realize the full value and benefit of the tool. For those who are not in the mood to read any more, I will sum it up for you. I have found expressor's data integration platform to be less developer centric and more approachable by non-technical users. Throughout my career in the Business Intelligence (BI) and Data Integration ( DI ) industry, there is one activity that has been the same; positioning the differences between my company's software and the competition's. So exactly what is this ?

</b>*} {*style:<b>Templates . What is an expressor Schema? Expressor Schemas describe a structure of data (active metadata) that is read from or written to the selected data source before or after processing in a Dataflow. Simply stated, they are used to define how the data structure looks to the up stream and down stream Operators used in an expressor Dataflow. It represents a structured, reusable and consistent approach to eliminating the need to change the underlying ETL Dataflow if something in the source was to change.

A Delimited Schema defines the data structure (active metadata) for whose attributes are separated by a delimiting character such as commas, pipe, tabs, space etc. You create this when using Read and Write File and Custom Operators. A Table Schema defines the data structure (active metadata) of the table to be used in the dataflow. Schemas can be shared and saved as types to be reused with other operators and dataflows. When opening a schema to view or modify its attributes or mappings you will see a right and left view. Our Approach - Data Integration | expressor. Tutorial: Error Handling, Validation and Cleansing. Error Handling, Validation and Cleansing with Semantic Types and Mappings Tutorial expressor ETL applications can setup data validation rules and error handling in a few ways.

The traditional approach with many ETL tools is to build in the rules using the various ETL operators. A more streamlined approached is to also use the power of expressor Semantic Mappings and Semantic Types. Semantic Mappings specify how a variety of characteristics are to be handled when string, number, and date-time data types are mapped from the physical schema (your source) to the logical semantic layer known as the Semantic Type. Semantic Types allow you to define, in business terms, how you want the data and the data model to be represented. The use of these methods both provide a means of attribute data validation and invoking corrective actions if rules are violated. View the Demonstration NOTE: Semantic Mapping rules are applied first before Semantic Type rules. Prerequisites: DO NOT UNZIP it Save it Code: Expressor: Version 3.6 – A Significant Game Changer | Blogs | expressor Community.

In mid to late March of this year, expressor software will be releasing version 3.6 of its user friendly data integration platform. This anticipated release marks some major milestone developments that trump all previous versions. Adding to the recent extensions for Salesforce, QlikView and Excel we have now enhanced the user experience and unleashed impressive scalability and performance.

Here are the notable improvements that will be a part of expressor version 3.6: First we'll cover the most obvious enhancements. I t's a well-known fact that Red Hat provides one of the world's most popular Linux based operating systems. Partitioning 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.

Teradata is the global leader in data warehousing and big data analytics. Bulk Artifact Upgrading? Regards, Michael Tarallo Technology Evangelist expressor Software Follow me: @mtarallo. Expressor 3.6 / QlikView Integration. Video Tutorial: Using expressor to Read Salesforce and Write QlikView files. Great tutorial, I'm doing it by my own, I've created a free account at salesforce ( I've already have username, password and token and also I tested the connection in expressor studio) but when i created the read from salesforce operator and I create a new schema, when I select the connection, I'm having this error: Cannot establish connection, errorCode 3 message: "global.authenticate: sfdcblokapi.autenticate: Missing (or bad type of) username parameter (must be non-empty string).

" I'm using Expressor 3.7.1 (free downloaded from qliktech). If you have an idea about why I'm having this trouble please let me know. Thank you in advance.