Learn BODS in a Day

Jimbo's picture
Submitted by Jimbo on Sat, 11/16/2019 - 13:26

Data FlowProficiency and confidence in the use of Business Objects Data Services (or "BODS") can be achieved in a single day by an experienced programmer. BODS does most of what Access does and comes with some exceptional features right out of the box.

Features like importing from ever-changing source files, exporting to UTF-8 text with headers, exporting to Excel with multiple tabs and extracting tables directly from an SAP system were not available in off-the-shelf products like Access and had to be added in the form of VBA snippets in the past. BODS comes complete with these features and many more for extracting and transforming source and load files.

Data FlowBODS has a graphical interface that allows for the creation of complex Data Flows which work in much the same way as joins and nested queries in Access. A source structure can be passed into a query and the results can then be passed into another query, split, recombined and then finally written out to another structure.

These videos can be used to transition from ETL tools like Access (or Talend, DataStage, Data Integrator . . .) to BODS in a single day. They rely on the user having advanced knowledge of programming languages like SQL and Java.