Integrating APEX and Social Media.key

30 Pages·2015·3.13 MB·English

Integrating APEX and Social media
for Application Express 4.2 and 5
(using Oracle XE 11.2)
a presentation by
1
Who is Smart4apex
Reliable Apex solutions by shared knowledge
2
Who is Smart4apex
• independent contractors in a cooperative,

• present (kscope US, oracle open world US, apex-world NL, user groups (throughout Europe)

• share knowledge

• do projects

• use each others network

• not only for new assignments

• also to help customers in time of a full schedule
3
Who is Smart4apex
Arthur Kolkman Sergei Martens

(driving force/founder)
Learco Brizzi
Toine Tuerlings
Roel Hartman

(chairman/founder)
Dick Dral
Christian Rokitta
(secretary/founder) Richard Martens
(treasury/founder)
4
Who am I?
Richard Martens
• Independent Consultant since 2012
• smart4apex founding member (2010)
• Oracle since 2002 (Oracle 8i)
• PL/SQL, Apex, HTML(5), CSS(3), Javascript, XML, XSLT
• Special interest in UI
• RIMA on Oracle Forums
• Trainer at skillbuilders.com
5
Agenda
1. Signing up as a developer at the 
 Presentation available on Google Docs:
Social Media https://goo.gl/rVXo3e
2. Authentication Code is available on:
3. login flow http://apex.world
• authentication plugin
• scopes and code
4. Reading from Google
• Calendar
• Contacts
• Drive
5. Reading from Facebook
6. Send email using Gmail
7. Merging users
6
Warning
• This session will not include a ready to use
solution for Social Integration into Apex
• Instead it will give guidelines on what you need
to do to create the integration.
7
No twitter
• Twitter uses OAUTH instead of OAUTH2

there is a big difference between the two
• Alternatively we can use javascript client
8
No Linked-in
• Linked-in uses an SSL algorithm that is not
supported by Oracle 11.2.0.1
• Use reverse proxy instead
9
Signing up as a developer
• We must sign up as a “developer” before we can connect our application
• Google: https://console.developers.google.com/
• Facebook: https://developers.facebook.com/
• Linked-in: https://developer.linkedin.com/
• Twitter: https://dev.twitter.com/
• After signing up
• create a project
• generate “API-key” and “Client Secret”
10