Results 1 to 3 of 3

Thread: JDE and Tableau

  1. #1
    Senior Member
    Join Date
    Nov 2000
    Location
    E Greenville, PA, USA
    Posts
    1,229

    Question JDE and Tableau

    I'm involved in trying to use TABLEAU to report from World (A7.3)
    We're able to connect to the iSeries, get into a "library" (aka "schema"), and drag a table into Tableau.

    For fun, I've been trying to create a "visualization" based on Address Book (F0101).
    Some columns, ABAN8 and ABALPH, display as expected.
    Most are displaying as hex.

    I showed this to the consultants leading the project, and they're not sure what's going on,
    BUT the same thing happens when they try to get it to work.
    (So I'm not "special" for THAT reason)

    We're using "iSeries Access ODBC Driver" to connect.

    Has anyone here worked w/Tableau & World?
    How did you connect?
    Have you run into this issue?
    Can Tableau drill into a MEMBER w/in a physical file?
    Is it pronounced "Tab-blow" or "Tab-blue"?

    TIA and regards
    Frosty
    Frosty
    *
    Back to the future supporting A7.3 while moving to Oracle EBS

  2. #2
    New Member
    Join Date
    Nov 2006
    Location
    Philadelphia, PA
    Posts
    10
    This sounds like some sort of CCSID or translate binary. configuration setting on the ODBC driver.

    I found this on this in another forum, https://community.tableau.com/ideas/1196

    After setting up your ODBC data source, the tabs at the top should all be default values except for “Conversions”. Chick here and make sure there is a check next to the “Convert binary data (CCSID 65535) to text”. These directions are from ODBC driver version 13.00.01.00

  3. #3
    Senior Member
    Join Date
    Nov 2000
    Location
    E Greenville, PA, USA
    Posts
    1,229
    Thanks.
    Yes, the "conversions" tab was what we needed to change.
    Frosty
    *
    Back to the future supporting A7.3 while moving to Oracle EBS

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
The legal restrictions and terms of use applicable to this site are available here.
Use of this site signifies your agreement to the terms of use.
JDELIST is NOT affiliated with JD Edwards® & Company, Oracle or Peoplesoft. Contents of this site are neither endorsed nor approved by JD Edwards® & Company and, or Oracle.